Dear All,
I have the following formula which clears input if a date picker selects:
Earlier than today
More than month
Weekend
After 9:10 same day
I also want to include a error if someone does this like a notification after its cleared. Can anyone help with this?
Kind Regards
Daniel
If(
Self.SelectedDate < Today() ||
DateTimeValue(Now()) > DateTimeValue(Text(Self.SelectedDate & " " & Time(9, 10, 0), "MM/DD/YYYY hh:mm AM/PM")) ||
DateDiff(Today(), Self.SelectedDate) > 31 ||
Weekday(Self.SelectedDate, StartOfWeek.Monday) = 6 || // Saturday
Weekday(Self.SelectedDate, StartOfWeek.Monday) = 7, // Sunday
Reset(Self)
)