DTPicker Default Value is Wrong

[diwin]

I have dtpicker in a form to add a new order. It displays the current date and time (short format) when I open the form, but only the incorrect time of 12:00 AM is the actual value that the control holds. When this is added to the table on submitting the order, it is then read as (can't remember specific date) some date in 1899.
1. Why would the value of the control be 12:00 AM (+ no date)???
2. Why is that in turn read as coming from the year 1899???

 

[SepMan76]

Hey diwin!... I came across your question looking for an answer to DTPicker myself. DTPicker doesn't have a "default value" that you can put formula's (=Now() ) in. It leaves a bit to be desired.

Anyway, it does have a "value" property. Check to see what yours is, my bet it it is 0 or Dec 30, 1899 12:00:00 AM.

Dates in VB (or VBA) are simply number (doubles to be more exact) the left of the decimal is the number of days after Dec 30, 1899 and the decimal to the right is the number of seconds after midnight (it actually get down to milliseconds I think). So the number 1.1 is Dec 31, 1899 2:24:00 AM (0.1 means 2:24:00 AM)

anyway, hope this helps.

Chris