I am trying to validate the input of a field during the UPDATE block. I have a simple date range and I want to make sure that the second date entered is greater than the first date entered. I have the followign code in place for the UPDATE, but it is not passing validation no matter what dates I enter into the fields. The second date always fails validation.
Code:
UPDATE
loc
loc1
dept
dept1
upartlist
ly-n
edate
edate1 VALIDATE(edate1 > edate, "Invalid Date")
excelfile
WITH FRAME a.