Guest_imported
New member
- Jan 1, 1970
- 0
How do I calculate what week of the year a date field is? For example, I'd like to know that the date field with a value of 12-27-2000 is the week number 52. How do I do this? help again!!!
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I calculate the week of a date field?
- Thread starter Guest_imported
- Start date
- Status
chandhureddy
Programmer
Hi,
i dont think there is a ready made function to do this. you need to write little bit of coding unsing the Year, Month,
day functions. find out what day of year it is, out of 365 days. then divide it by 7.
I hope this may help you
i dont think there is a ready made function to do this. you need to write little bit of coding unsing the Year, Month,
day functions. find out what day of year it is, out of 365 days. then divide it by 7.
I hope this may help you
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question