Date Format

[TSI01]

Hi there,

Can anyone help me. I have a field that contains dates in the format "dd-mm-yyyy" which is okay for double digit months. What I need to do is tell the system to enter a "0" before a single month digit to amend the date from "12-2-2005" to "12-02-2005". I can do it, but only by creating 4 different queries, can anyone help me symplify it?
The only other problem is that the field type is text.

 

[Crowley16]

hmm, I thought the "dd-mm-yyyy" format already did that...

are you using the given short date format or specifically calling the "dd-mm-yyyy" date format?



--------------------
Procrastinate Now!

 

[ZmrAbdulla]

While you are in the design view of the query right click onthe field and choose properties set the format there.

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.

 

[TSI01]

Tried that, no format option was given in the drop down.

 

[Crowley16]

you'll have to do it in the sql then...


format(field, "dd-mm-yyyy")

--------------------
Procrastinate Now!

 

[PHV]

The only other problem is that the field type is text
myDate: Format(CDate([text field]), 'dd-mm-yyyy')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TSI01]

Thanks everyone!