Date Logic

  • 4 August 2015
  • 1 reply
  • 1 view

Badge +1

I have two date fields on a travel form ("Date Travel Starts" and "Date Travel Ends").  I need to make sure user puts a later date in the "Date Travel Ends" field (when compared to the "Date Travel Starts" field).  I cannot figure out the formula for this validation.  datediffdays seemed to be the right path, although it always results in whole numbers.  Any ideas?  Thanks


1 reply

Badge +1

If comparing two date controls you can (DateControl1 <= DateControl2) this is to mean that DateControl1 must be greater in order to be valid and allow submit.

Reply