how do i get the week number ?

hello,

are there functions that would give you a week number from a given date ?
thank you for any help.

Tran.

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

Try in debug window:
? Format(Date, "ww")

thank you, it works great !!