Runtime Error while executing Assignment
I have 3 fields at 1) ValidStartDate 2) ValidEndDate 3) Item Status.
I have written assignment to check if my current system date and time falls between validstartdate and validenddate, then my Itemstatus field should be active else inactive.
If(SYSTIME(0)>=validstartdate AND SYSTIME(0)<=validenddate, Active, Inactive).
SYSTIME(0) Is current system date and time
and my validstartdate and validenddate fields data type is Literal Date
Assignment Field: ItemStatus
Error Message: "A runtime error occurred while evaluating an assignment, validation or calculated field".
Could any one please suggest where went wrong, The same logic is executing sucessfully in validation with TRUE, FALSE.. in place of Active and Inactive.
Thanks in advanced.