esther2003
Instructor
I need a formula that determines the week number of the Currentdate.
This needs to be based on the financial year.
Any ideas?
This needs to be based on the financial year.
Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formula to determine week number
- Thread starter esther2003
- Start date
- Status
I haven't fully tested this cause I'm goin to a meeting now, but this should get you started :
Local DateVar FinYear := Date(Year(currentDate),04,01);
If CurrentDate >= FinYear then
DateDiff("w",FinYear,currentdate) else
52-DateDiff("w",currentdate,FinYear)
Replace the items in bold with your actual financial start month and day.......
Reebo
UK
Local DateVar FinYear := Date(Year(currentDate),04,01);
If CurrentDate >= FinYear then
DateDiff("w",FinYear,currentdate) else
52-DateDiff("w",currentdate,FinYear)
Replace the items in bold with your actual financial start month and day.......
Reebo
UK
- Status
Similar threads
- Locked
- Question
- Locked
- Question