AnsweredAssumed Answered

Validate selected Date/Time with CurrentDate/Time

Question asked by bimi82 on Jan 9, 2019
Latest reply on Jan 9, 2019 by bamaeric

Hello

 

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:

 

FromDate<Current Date

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

Outcomes