Function to return Day Name?

  • Thread starter Thread starter Gary Smith
  • Start date Start date
G

Gary Smith

Hello--

Is there a type of date function that returns the Day of
the week, given the date?

something like: DayName(#1/1/04#) = "Thursday"

Anybody? Thanks as always...

--Gary
 
Gary,

Try ...

Format([MyDate],"dddd") or Format(Date(), "dddd") or
Format(#1/1/2004#, "dddd")

hth,
 
Thanks, Cheryl. I'll give it a shot. --Gary

-----Original Message-----
Gary,

Try ...

Format([MyDate],"dddd") or Format(Date(), "dddd") or
Format(#1/1/2004#, "dddd")

hth,


--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Hello--

Is there a type of date function that returns the Day of
the week, given the date?

something like: DayName(#1/1/04#) = "Thursday"

Anybody? Thanks as always...

--Gary
Click to expand...


.
Click to expand...
 
Gary said:
Is there a type of date function that returns the Day of
the week, given the date?

something like: DayName(#1/1/04#) = "Thursday"
Click to expand...

Format(DayName, "dddd")
 
Sorry, that won't work. DatePart only returns integer values, not text (and
"dddd" isn't a valid parameter for it)
 
Back
Top