Corvert date to Day value

[Les]

I have a text box in a form which picks up a date value. This is formated
to display "ddd" as the day of the week. This works fine and it is
displayed as I need it..

I need to read the day value as text to evaluate if it is a "Sat" or "Sun"
rather than its current value of dd/mm/yy

Is there a simple way to do this?

Thanks

Les

 

[Allen Browne]

Try the Weekday() function, and compare to the numbers 1 to 7.

 

[Les]

Thanks Allen that works great!

Try the Weekday() function, and compare to the numbers 1 to 7.