I really need the help of the experts and gurus on here because I really need your help with a date and time format issue.
Firstly, what is happening is that I am entering the correct date date format of dd/mm/yyyy into my input textbox. Ex. 01/04/2014 (April 1, 2014)
Secondly, I am writing that value from the input textbox into my MDB database: dd/mm/yyyy. Ex. 01/04/2014
Thirdly it seems that my MBD is automatically re-arranging my date of dd/mm/yyyy into yyyy-mm-dd (US standard)
So that when I retrieve the raw date from my mdb I get a long date of: Sat Jan 4 00:00:00 EST 2014
Any help on this is greatly appreciated.