date format

[Kaybaj]

please i want my date to read dd/mmm/yyyy so that users can enter their date into access in that format and retrieve it in that format too without access changing it into mmm/dd/yyyy

i need help cause its frustrating

thanks

 

[JamesMcS]

Access always stores days in mm/dd/yyyy format, that can't be changed.

To force a user to enter a date in a particular way, use an Input Mask, which can be defined at table design level - look it up in the help file, it explains everything.

 

[JamesMcS]

And to display a date in a particular way, change the Format of the control you're using to show it, i.e. a text box can be formattted to show a date in long date or short date format.

 

[Kaybaj]

thanks for that, but even after formating that way dates like 6/7/2010 would read 7/6/2010 and when user query a report they dont seem to get what they want.

 

[JamesMcS]

This explains dates quite well:

http://www.fontstuff.com/access/acctut06.htm#dates

 

[Kaybaj]

thanks
that helps a lot

 

[rodmc]

KayBaj

just had a thread thread resolved which is very close to you're problem, follow ChrisO's comments and you'll be sorted in no time.

http://www.access-programmers.co.uk/forums/showthread.php?t=191573

 

[Kaybaj]

yeah thanks bro exactly what i wanted..