Financial Year

R

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
 
B

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

week entry new 3
week entry 1
week entry 1
Pivot Table by Financial Year 2
Financial Year Weeknum 1
Too Clever... 3
Get date for start of week 3
sum a column range basing on financial year. 5

Top