DateTimePicker conrol

Closed
mikeoe2003
Posts
25
Registration date
Thursday November 1, 2012
Status
Member
Last seen
March 27, 2014
- Jan 26, 2013 at 09:58 AM
rizvisa1
Posts
4479
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 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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