G
Guest
How do I convert a number ( 1 to 7 ) to Sunday, Monday..... Saturday.
say for eg. a no. 3 should be formatted as Tuesday
say for eg. a no. 3 should be formatted as Tuesday
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Try
Format([FieldNumber],"dddd")
Format([FieldNumber],"dddd")
J
John Vinson
How do I convert a number ( 1 to 7 ) to Sunday, Monday..... Saturday.
say for eg. a no. 3 should be formatted as Tuesday
Use the Choose() builtin function:
DayName: Choose([DayNumber], "Sunday", "Monday", "Tuesday",
"Wednesday", "Thursday", "Friday", "Saturday")
John W. Vinson[MVP]