Fiscal Week Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Morning

I have a textbox that displays a user entered date. When this date is
entered I want another text box to display the week number for that date.
However, this needs to be based on the fiscal year with the year starting on
27/03/05 so this will be week 1.

Any help on how I go about this will be much appreciated.

Thank You
 
WeekNumber = DateDiff("ww", #3/27/2005#, TextBoxDate) + 1

This will only work if your TextBoxDate is always greater or equal
27/03/2005 so you might want to validate before calculating week number.
 

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

Only want to see first record 1
Access 2 Digit year in Access Text Box 3
fiscal year 5
help with fiscal year 4
End of Quarter Based on Fiscal Year 2
Week Number - Fiscal Year 1
Need Help with Conditional Formating?? 2
Group by fiscal months 5

Back
Top