DatePart function

  • Thread starter Thread starter Day of week
  • Start date Start date
D

Day of week

I need to find the day (Sun,Mon,Tues....) from a date field (6/9/2009). I
tried DatePart, However, all I get is a number. Can anyone help?

Thanks,
Jose
 
On Thu, 2 Jul 2009 10:22:38 -0700, Day of week <Day of
I need to find the day (Sun,Mon,Tues....) from a date field (6/9/2009). I
tried DatePart, However, all I get is a number. Can anyone help?

Thanks,
Jose
Click to expand...

Just set the Format property of the textbox in which this is displayed to
"ddd"; or use

Format([datefield], "ddd")

if you need it as a text field in a query.
 
Back
Top