Problem with date picker as i get the default value as 0

[Pavan.Sada.PS]

Dear friends,

I am unable to figure out on where the problem is lying with, as I am getting incorrect values.

I am at the initial stage of building a user form for one of my process and I am experiencing 3 errors from the Date picker control ( DT1stExecutiveApproval , DT2ndExecutiveApproval & DTExptOnBoardDate )

If I execute the Record data button with the blank user form template. those 3 controls works fine and the cells will have the dates selected on the date picker (I do get error from one of the if conditions, But that's fine I know how to tackle that)

But if I fill all the relevant data in all the tabs. there lies the real problem.. my date picker will give the output as 0 and the cells will populate as 12:00 AM and I don't know which code will reset the values to 0 for all those date picker control..

one thing which wonder me is.. there are 4 date picker controls in this user form the 1st one works really well and I wonder for the rest 3 date picker controls..


AM I REALLY MISSING ANY KNOWLEDGE?

 

[pike]

Friend
avoid the bult-in date picker.. it has problems
This freebe works well [URL]http://www.excel-it.com/excel_datepickers.html[/url]
with the code to see the values of the date picker when you press the add button .. the values of the date pickers change as soon as you change page

Debug.Print Format(Me.DTGRB_ReviewDate.Value, "Short Date")
Debug.Print
Debug.Print Me.DT2ndExecutiveApproval.Value
Debug.Print Format(Me.DT2ndExecutiveApproval.Value, "Short Date")
Debug.Print
Debug.Print Me.DT1stExecutiveApproval.Value
Debug.Print Format(Me.DT1stExecutiveApproval.Value, "Short Date")
Debug.Print
Debug.Print Me.DTExptOnBoardDate.Value

so if you click daata data on the approval page all three on that page work and the forth errors

 

[Pavan.Sada.PS]

Hey Pike,

Welcome to the Chandoo.org. your Response was very much helpful. Thanks for the Freebee.

Regards,
Pavan S