DT Picker
 

Hi,

How do I get the value of a DT Picker. For example I select a date
4/1/2005. How do I get 4/1/2005. I want to have two DT picker and compare
the value between them. Thank you in advance for help..

DT Picker
 

If you are talking about the Calendar control then all you do is get its
value property - UserForm1.Calendar1.Value

Alok Joshi

"Alex Martinez" wrote:

Hi,

How do I get the value of a DT Picker. For example I select a date
4/1/2005. How do I get 4/1/2005. I want to have two DT picker and compare
the value between them. Thank you in advance for help..

DT Picker
 

Also to compare try:

datediff("d",UserForm1.Calendar1.Value,UserForm2.C alendar2.Value)
the "d" is the day type, this wil return the number of days between the two
date, supplied from the calendar objects.

Regards

"Alok" wrote:

If you are talking about the Calendar control then all you do is get its
value property - UserForm1.Calendar1.Value

Alok Joshi

"Alex Martinez" wrote:

Hi,

How do I get the value of a DT Picker. For example I select a date
4/1/2005. How do I get 4/1/2005. I want to have two DT picker and compare
the value between them. Thank you in advance for help..