Click to See Complete Forum and Search --> : how do i get the week number ?


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 !!