DateTimePicker conrol

[Closed]
Report
Posts
25
Registration date
Thursday November 1, 2012
Status
Member
Last seen
March 27, 2014
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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