Function to return Day Name?

[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

 

[Cheryl Fischer]

Gary,

Try ...

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

hth,

 

[PC Datasheet]

DatePart("dddd",#1/1/04#)

 

[Gary Smith]

Thanks, PC Datasheet. --Gary

-----Original Message-----
DatePart("dddd",#1/1/04#)


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com





.

 

[Gary Smith]

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

.

 

[Marshall Barton]

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

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

Format(DayName, "dddd")

 

[Guest]

Thanks, Marsh. --Gary

-----Original Message-----


Format(DayName, "dddd")

 

[Douglas J. Steele]

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