If I'm working with dates, I'll make sure I'm using a date:

dayofweek = weekdayname(weekday(dateserial(2009,4,30)))






sunilpatel wrote:

dayofweek = WeekdayName(Weekday(30 - 04 - 2009))

why is Friday returned not Thursday.

--

Dave Peterson