How to display date into required format

[sushmitha]

I have date in mm/dd/yyyy format. Now I need to display this date into dd-mon format. How to do that ???

 

[Brianwarnock]

Have you tried the Format function?

 

[MSAccessRookie]

I have date in mm/dd/yyyy format. Now I need to display this date into dd-mon format. How to do that ???

You do not specify where you want to display the date that you have.

1. Is the date being displayed on a form?
   • You can use the Format Attribute of the Control to get what you want.
2. Is the date being selected by a Query to display in a report?
   • You can use the Format() Command: Format(YourDate,"dd-mmm-yyyy")
3. Somewhere else?
   • Please provide Details

 

[Brianwarnock]

This is the queries forum so I assume its in a query, plus thposter only wants dd-mon. I thought that a read of the Format function rather than a total hand hold would be beneficial.

Brian

 

[Rabbie]

This is the queries forum so I assume its in a query, plus thposter only wants dd-mon. I thought that a read of the Format function rather than a total hand hold would be beneficial.

Brian

I agree that if you point a person in the right direction and tell them what to look up in Access Help then they tend to remember it better and develop their Access skills. The Hand Holding approach tends to encourage them to sit back and let us do their work for them