
Active Member
Dashboards
Power Query
Power Pivot
Power BI

August 13, 2019

Hi all,
I've been trying to create a date picker form using the method shown in the 9 July 2015 blog (https://www.myonlinetraininghu.....ate-picker).
I've encountered some errors when trying to input the date into the text boxes and have previously been asking Catalin for some help.
Basically, the date is showing up as time.
Any help would be appreciated!
Thanks in advance!

Active Member
Dashboards
Power Query
Power Pivot
Power BI

August 13, 2019

Hi Phil,
Thanks for the solution!
I've managed to get the date working for Registration Date field as well.
However, something weird happens.
When the date is chosen for Registration Date, it all seems fine. But after I click to Save Date, the input changes to American date formatting.
The Birthday field doesn't do this when saving the date.
Any ideas as to why?
Cheers,
Gabriel


October 5, 2010

Hi Gabriel,
Similar problem. You have 2 bits of code setting the reg date.
In this sub your setting it to CValue after you'd set it to the date in the calendar. So I've just commented out the 2nd line
Private Sub RegDate_Enter()
DatePickerForm.Show
'RegDate.Value = CValue
End Sub
Regards
Phil
1 Guest(s)
