DatePart function

[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

 

[Jerry Whittle]

Format([TheDateField],"DDDD")

Use 3 D's if you want the abbreviated date.

 

[John W. Vinson]

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

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.