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)