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