Conversion

A

Anand Vaidya

How do I convert a number ( 1 to 7 ) to Sunday, Monday..... Saturday.
say for eg. a no. 3 should be formatted as Tuesday
 
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
Click to expand...

Use the Choose() builtin function:

DayName: Choose([DayNumber], "Sunday", "Monday", "Tuesday",
"Wednesday", "Thursday", "Friday", "Saturday")


John W. Vinson[MVP]
 
Top