Day of Week

[stoned77]

Can anybody please tell me how i can find out what day of the week its is from a date string.
Thanks

dave

[Glenn]

You can use the format function to get the numeric day of the week with the following code:

dim dayofweek as string

dayofweek = format$(now(),"w")

After this runs day of week will contain 1-7 for Sunday - Saturday.

[Alfred]

Use VB function WeekDay():

i = WeekDay(SomeDate)

[Glenn]

There just too many functions to remember them all. Alfred is definitely correct the weekday function is what you want.