Date format

[Johny]

Hey,

I have a date/time field in my 'Assignment' table. (ex. 5/06/2004 11:32:45).
Now I made a query based on this table that has to format the date into 5/06/2004. It has to be done at this level and not after I pulled out the data from the database because the data goes straight into my listbox.

Any ideas?

I guess this must be somethin' very easy but can't seem to figger it out

 

[Mile-O]

NewField: Format(myDate, "dd-mmm-yyyy")

Or whatever format you want it in.

 

[Johny]

NewField: Format(myDate, "dd-mmm-yyyy")

Or whatever format you want it in.

thanx, you helped me alot. Didn't know ya could use vba function in the query design.
I used:

Aanvraag: FormatDateTime([Datum];2)

thanx again