Convert a day number to the name of the day

[Pat]

Is there an Access function that can convert a day number (eg 6) to its name (eg Friday)?

[HansV]

You can use the WeekdayName function:

WeekdayName(6, False, 1) returns "Friday"

WeekdayName(6, True, 1) returns "Fri"

You can replace 6 with a variable or expression, of course.

Or, if you have a date variable, use Format(datevariable, "dddd") for "Friday" or Format(datevariable, "ddd") for "Fri".

Note: both WeekdayName and Format will use the local language, i.e. on a French-language system you'd get "vendredi" and "ven".

[Pat]

Thanks Hans, i didn't know about that function, i came up with a convoluted formula which doesn't take into account ther start day of the week:

Format(Date + (iDay - Weekday(Date)), "dddd")

I will use yours.