Financial Year

[R A Turner]

Self taught access 2003.
I have an unbound field on a form
"Today is "dddd" in week number "ww yyyy"
which works well. In Au. the financial year
commences on 1st July I would like to have this field commence
the week number from this date. e.g. 02/07/07 was the first week
in the financial year 2007/2008.
Any help greatly appreciated
Thanks

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

One way to get current fiscal year is to use:

FicalYear = Year(Date()) + (Month(Date()) \ 7)

? Year(Date()) + (Month(Date()) \ 7)
2008

To get the week number, you could try using the DateDiff() to get the
difference in the weeks for the start of the fiscal year to Date()

 

[R A Turner]

Thank you, I'll give that a try

One way to get current fiscal year is to use:

FicalYear = Year(Date()) + (Month(Date()) \ 7)

? Year(Date()) + (Month(Date()) \ 7)
2008

To get the week number, you could try using the DateDiff() to get the
difference in the weeks for the start of the fiscal year to Date()