Runtime Error while executing Assignment

[Former Member]

Hi Experts,

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.

Logic:

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.

Thanks

Bharat

[Former Member]

HI Experts,

Myself found the solution...

Thanks

Bharat

[petr_solberg]

Hi,

we have the same problem:

A runtime error occurred while evaluating an assignment

What is the solution ?

Thank you.

Petr.