Date expression

[schneitodd]

I am looking for an expression that can be used to pull out the date from a date & time cell.
For example, I have a column of cells with the format of "12/31/02 13:00". I would like to sort data by date (12/31/02).

Initially I tried using =left(...,10) but for dates like 9/1/02 it doesn't work as well.

Any ideas...

 

[Joe4]

If your date/time field were named MyDate, try this:

NewDate: Format([MyDate],"mm/dd/yy")

Then you can sort the query on this new calculated field.

 

[schneitodd]

While trying a number of things in the interim,
I used the DATEVALUE expression. The result appeared to give me "mm/dd/yy" from the "mm/dd/yy hh:mm" format.

Is this a bad choice?