Getting day of the week from date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Just use the format function.

Format([SomeDate],"ddd") for abbreviated name
or
Format([SomeDate],"dddd") for full name
 
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...
 
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...
 
Back
Top