Getting just the date from date/time stamp

[Lory]

I have a query based on an imported table that I would like to sort the records on it by date. However, the date field is actually a date/time stamp.

Is there a way to extract just the date without the time?

I certainly hope so!

 

[mark curtis]

Format(YourDate, "dd, mm yyyy")

Format(YourDate, "Long Date")

Format(YourDate, "Short Date")

 

[Lory]

Thank you!

I knew there was an easy way to do it...but I couldn't remember how!

Thank you so much!

Lory

 

[Mile-O]

That would still leave the time part although just showing the date part.

You acn use the DateValue() function to get just the date.

i.e

=DateValue(#22/05/03 12:05:29#)

would return exactly:

22/05/03