Click here to Skip to main content
14,879,536 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to save date in access database in "yyyy/MM/dd" format?

1 solution

The quick answer is: don't.
The only way to save date based values in any format is to convert them to strings, and that is a very poor idea. Store them as dates, and save formatting for you presentation layer so you can either display them in a particular format, or in the format the user is most comfortable with (i.e. as set on his system)

If you store them as strings, it severely limits what you can do easily with them when you want to do any form of comparison with them.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900