How do I convert a weekday number to a string?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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...
 
Back
Top