Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
04-03-2014, 09:27 PM #1
- Join Date
- Sep 2011
- Thanked 0 Times in 0 Posts
Swtiching date formats of yyyy-mm-dd and dd/mm/yyyy to MS MDB format of mm/dd/yyyy
I really need the help of the gurus/experts on this forum,
I need your help.
The function should transform the date from a date format of either yyyy-mm-dd and dd/mm/yyyy into
How on earth does one do this? It seems impossible, because my users will enter in the date format that they grew up to, but the DB in the backend does not recognize the format as being valid, therefore I need the date into a mm/dd/yyyy format in order to write it back to the DB.
Much thanks and appreciation for all your help and support.
04-04-2014, 12:36 AM #2
I see a lot of webpages using selects to avoid this problem:
Users who have thanked xelawho for this post:
04-04-2014, 01:11 AM #3
- Join Date
- Jun 2002
- Thanked 256 Times in 252 Posts
Or use HTML5's
<input type="date" />to use the browser's built-in date control with datepicker. If the browser does not support it, then use xelawho's suggestion or use a datepicker plugin.