Previous Topic Next Topic

DateTimePicker conrol

Closed
mikeoe2003 Posts 24 Registration date Thursday November 1, 2012 Status Member Last seen March 27, 2014 - Jan 26, 2013 at 09:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 26, 2013 at 10:31 AM
Hello,
I have an access database and i have set the Format to 'Short' and i also set the Format of the control on the property window to SHORT (1_/26/1975). But when i insert a date into my access database using this control on my VB,net form, it appears as LONG (1/26/1970 3:41:54 PM) In the access database and this makes it impossible to retrieve information from my database using the date as a parameter


1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 26, 2013 at 10:31 AM
I believe that format is only for viewing. Underlying data is still date. There could be two ways you can do what you want, when you insert data, format it to short form and insert that value. Or when you retrieve data, have data formatted to Short form
0