Retrieve only the date of the control date picker

  • Thread starter Thread starter Kon
  • Start date Start date
K

Kon

How can I retrieve only the date of the microsoft control Date-time picker.
I Used the shortdate but probably this is only the format, the actual value
is stile (date time) I want to cut the time.
I use the value of date-time picker in a link child - master subform and
when it puts the time I can never synchronize them.
 
Kon said:
How can I retrieve only the date of the microsoft control Date-time picker.
I Used the shortdate but probably this is only the format, the actual value
is stile (date time) I want to cut the time.
I use the value of date-time picker in a link child - master subform and
when it puts the time I can never synchronize them.
Click to expand...

You could use the Int function to get only the integer (date) part of the
control's value.

Int(Me!DTPControl.Object.Value)
 
Back
Top