Formatting Date/Time

[xcmav66]

I know this is a simple question, but I'm having trouble figuring out how to do it. How do I format a date/time field in a query from "12/18/2008 12:00:00 AM" to just "12/18/2008"? Thanks.

 

[Brianwarnock]

Can we clarify whether you mean that you just wish to see the date Format([datefield], "dd/mm/yyyy") for uk format
or just work with the date

Datevalue(datefield)

Brian

 

[pbaldy]

Look at the Format() function in Help.

 

[xcmav66]

I tried the Format() function but it gave me an "Undefined function 'Format' in expression"

To clarify, I am just trying to truncate the time of day from the date.

 

[The_Doc_Man]

If Format or Format$ are not defined, you have a broken reference somewhere. Search this forum for "References" to see how to fix that.

 

[xcmav66]

I'm not sure if I'm using it correctly though. I'm just typing Format([DateField], "mm dd yyyy") into the expression box when in the query design view. Is this correct?

 

[Brianwarnock]

If by expression box you mean the Field row then yes , Access will place Expr1: in front of it. So looks like a reference problem.

Brian