Getting day of the week from date

K

ktm400

In one of my columns I have the date. I would like to display the day of week
in another column. I tried using datevalue to get a number - I then planned
to use the number to get the day. I cant get it to work...from this
DayNumber: DateValue([ReadingDate]) I just get the date.
Thanks for any help
 
J

John Spencer

Just use the format function.

Format([SomeDate],"ddd") for abbreviated name
or
Format([SomeDate],"dddd") for full name
 
K

ktm400

Thank you!

John Spencer said:
Just use the format function.

Format([SomeDate],"ddd") for abbreviated name
or
Format([SomeDate],"dddd") for full name



ktm400 said:
In one of my columns I have the date. I would like to display the day of
week
in another column. I tried using datevalue to get a number - I then
planned
to use the number to get the day. I cant get it to work...from this
DayNumber: DateValue([ReadingDate]) I just get the date.
Thanks for any help
Click to expand...
Click to expand...
 
K

KARL DEWEY

If you were looking for the number of the day of the week then --
Format([SomeDate],"w") defaults to Sunday as day 1.
You can offset to have another day as day 1 like this --
Format([SomeDate],"w",2) defaults to Monday as day 1.

ktm400 said:
Thank you!

John Spencer said:
Just use the format function.

Format([SomeDate],"ddd") for abbreviated name
or
Format([SomeDate],"dddd") for full name



ktm400 said:
In one of my columns I have the date. I would like to display the day of
week
in another column. I tried using datevalue to get a number - I then
planned
to use the number to get the day. I cant get it to work...from this
DayNumber: DateValue([ReadingDate]) I just get the date.
Thanks for any help
Click to expand...
Click to expand...
Click to expand...
 
Top