Announcements
I would like to be able to validate that on change, what is being entered in not in the past. I was able to do this on the datepicker, but its not looking at the hour and minutes. Any insight>?
Hi @Anonymous ,
To do this you'll need to combine the inputs for the datepicker and the dropdowns for hours and minutes:
DateAdd( DateAdd( DateValue.SelectedDate, HourValue.Selected.Value, TimeUnit.Hours ), MinuteValue.Selected.Value, TimeUnit.Minutes )<Now()
This formula will return true if the combined inputs are in the past. You may have to change the referenced to DateValue (DatePicker), HourValue (DropDown) and MinuteValue (DropDown) to match the actual names of the controls.
Hi,
you can use the formula below to get the selected date and time
DateValue.SelectedDate + Time(Value(HourValue.Selected.Value), Value(MinuteValue.Selected.Value), 0)
then you can check if it is in the past or not
If( Now()>DateValue.SelectedDate + Time(Value(HourValue.Selected.Value), Value(MinuteValue.Selected.Value), 0), Notify("past"), Notify("future") )
any doubts let me know
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
