Weekday Function 1

[tziviak]

I need a textBox to display the week day of the week-given a certain day in the form of Sun, Mon, Tue...
is there an easier way than an if statement?
if (weekday(DATE))=1,"Sun",IIF(weekday(DATE))=2,"Mon"....
Thank you

I'm putting this code in the control source of 15 textboxes-so is there a way for it not to be so redundant and repetitious?

Thank you

 

[combo]

What about:
format(DATE,"ddd&quot

combo

 

[tziviak]

I tried this and I got an error-what's wrong with my code?
=Weekday(Format([firstBilling],"ddd&quot)

 

[tziviak]

thanks -I got it to work

=Format(Weekday([firstBilling]),"ddd&quot

 

[combo]

You do not need to use Weekday function - Format and "ddd" will do the same with date.

combo