I am trying to validate a Date|Time with the current Date|Time so that it does not allow the user to submit the request when the selected date & time is less than current date/time.
I have tried following rules:
This validation works only if the FromDate is less than CurrentDate but excludes the time.
The time needs to be also validated so that a booking cannot be submited when date and time are in the past!
formatDate(FromDate, 'dd/MM/yyyy HH:mm') < formatDate(Current Date, 'dd/MM/yyyy')+ formatDate(Current Time, ' HH:mm')
This validation does not allow even if you select date/time is well in the future.
I am confused