Log In
Register
Home
Active Member
Dashboards
Power Query
Power Pivot
Power BI
August 13, 2019
Offline
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!
See Answer
October 5, 2010
Offline
Hi Gabriel,
You had two pieces of code setting the value of Birthday. The 2nd one set the value to a variable called cValue but this had no value so you ended up with 0 as your birthday i.e. 12:00:00AM.
Regards
Phil
Answers Post
Active Member
Dashboards
Power Query
Power Pivot
Power BI
August 13, 2019
Offline
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
Offline
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)
