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()

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
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com

 

[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()