kindjal
February 12th, 2000, 04:30 AM
hello,
are there functions that would give you a week number from a given date ?
thank you for any help.
Tran.
Johnny101
February 12th, 2000, 03:59 PM
You sure would think so, being as there are functions for WeekDay, WeekDayName, Month, Year, Minute, Hour and Second, but someone missed the boat for returning the number of the week.
If you find one, please let me know. :)
John
John Pirkey
MCSD
www.ShallowWaterSystems.com
Bruno
February 12th, 2000, 05:34 PM
Try in debug window:
? Format(Date, "ww")
kindjal
February 13th, 2000, 04:20 AM
thank you, it works great !!