How to show day of week

[Darrell Childress]

I have a form, one of the fields is called ShipDate. On this form, I
would like to have right beside the field a single letter (or 2 - Th for
Thursday) indicating the day of the week that the ShipDate is. For
example, if the ShipDate contained 3/22/10, right beside that I would
like a M (for Monday). I don't have a lot of room on the form to put the
whole thing (Monday)
Thanks,
Darrell

 

[Darrell Childress]

Never mind, I found it. Sorry, I got a little lazy and forgot to search
first.
I'm using =Format(ShipDate, "ddd")
I think I can live with 3 characters

 

[Arvin Meyer [MVP]]

=Left(Format([ShipDate],"dddd"),2)

 

[Darrell Childress]

Thank you Arvin, love these newsgroups!

 

[John W. Vinson]

I have a form, one of the fields is called ShipDate. On this form, I
would like to have right beside the field a single letter (or 2 - Th for
Thursday) indicating the day of the week that the ShipDate is. For
example, if the ShipDate contained 3/22/10, right beside that I would
like a M (for Monday). I don't have a lot of room on the form to put the
whole thing (Monday)
Thanks,
Darrell

You don't even need a separate textbox. Just use a Format property such as

ddd d/m

to show

Thu 3/25

You can still type 3/25 or any other recognizable date; it will redisplay it
with the day name as soon as you leave the control.