Return 1 if Created Date is Less than Login Date else 0

Question

Hello

I am struggling to add a Formula to return 1 if Created date is prior to Log date, other wise 0

I have tried

IF [LoginTime]<[CreatedDate]THEN'1' ELSE'0' ENDIF

but system does not like it

Has anyone got some sample or example of similar approach?

thank you

Myriam

MarqueeCrew · Accepted Answer

@MyriamB,

How about:

IIF([Created Date] < [Log Date],1,0)

make the data type BYTE.

If you define the data type as V_Wstring or any string, you'll run into errors.  That's because 0 & 1 are numbers.  If you want "0" or "1" as strings, then quotes are needed.

Cheers,

Mark