Hi all,
This might sound like a stupid question but I have been trying to find out what is the first weekday of the current month. I have use the below code which works for January but when I change the current day by changing the server date to another month its not correct.
curDay = day(Now)
curMonth = month(Now)
curYear = year(Now)
(Weekday(cdate(curMonth&"/1/"&curYear)))

It should return to me a number from 1 to 7 (Sun to Sat)
Jan 2004 .
What am I doing wrong?
I'd appreciate any help.
Thank
Graham

Use you brain, not your brawn!

Use DateSerial function to build your date - then there's no chance it will be misinterpreted:
Weekday(DateSerial(curYear, curMonth, 1))

Hi pgTips,
Thanks so much. It worked. I have been battling with this little problem for a couple of days.
Thanks Again

Use you brain, not your brawn!