Posted By

cueballrawn on 06/13/16


Tagged

year access T-SQL financial


Versions (?)

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


 / Published in: SQL
 

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

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

Report this snippet  

You need to login to post a comment.