How do I convert a weekday number to a string?

M

Michael Hannan

I'm using the Weekday function to produce the day of the week (integer); I
want to convert the integer to a string, for example, 1="Sunday." The
function is working but I'm getting a type mismatch error. Help!
 
D

Douglas J. Steele

To get the name of the day, don't use the Weekday function. Instead, use
Format([DateField], "ddd") to get Sun, Mon, Tue, or Format([DateField],
"dddd") to get Sunday, Monday, Tuesday...
 
Top