Extract day from date

[djl0525]

I have a date field formatted for long date. 1/10/2005 is a sample entry in this field. It displays as Monday, January 10, 2005. How do I get the day only out of this field so I can have it in a field by itself.

Maybe formatting for long date to get the day is an unneccesary step. Let's say I have 1/10/2005 in a date field. What do I put in the query criteria to get Monday from 1/10/2005? I want to get the day from the date.

And is there a way to do this in Excel too???

 

[SydneyGeek]

Build an expression in your query:
=Format([YourDate],"dddd")
For Excel, =Text(YourCellRef,"dddd")

Denis

 

[djl0525]

Cool. I'll try it first thing in the morning! Oops, it is morning... Must be time to go to bed.

 

[djl0525]

I put =Format([SES_STARTDT],"dddd") on the criteria row of my query for my date field which is SES_STARTDT. I get "The expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

Did I put the expression in the wrong place? I have no experience with the expression builder. Please advise.

 

[HomerJ]

You should actually put the expression on the field row. Access should recognize it as an expression then.