Return to Snippet

Revision: 70703
at June 13, 2016 19:51 by cueballrawn


Initial Code
Financial_Year*: IIf(Month([DateField])>3,Year([DateField]) & "/" & Right((Year([DateField])+1),2),(Year([DateField])-1) & "/" & Right((Year([DateField])),2))

Initial URL

                                

Initial Description
Derive and output financial year in T-SQL (MS Access), based on value in given date field.

Initial Title
Access (T-SQL) Financial year derived from date field

Initial Tags

                                

Initial Language
SQL