If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to show day of week
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 |
#2
|
|||
|
|||
How to show day of week
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 On 3/25/10 11:59 AM, Darrell Childress wrote: 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 |
#3
|
|||
|
|||
How to show day of week
=Left(Format([ShipDate],"dddd"),2)
-- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Darrell Childress" wrote in message ... 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 |
#4
|
|||
|
|||
How to show day of week
Thank you Arvin, love these newsgroups!
On 3/25/10 12:12 PM, Arvin Meyer [MVP] wrote: =Left(Format([ShipDate],"dddd"),2) |
#5
|
|||
|
|||
How to show day of week
On Thu, 25 Mar 2010 11:59:17 -0400, Darrell Childress wrote:
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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|