If then Statement using Dates

[lynnaberry]

I am trying to create an if then statement using dates, but I keep getting the error "Malformed IF Statement".

[RolandSchubert]

Hi @lynnaberry ,

remove the ")" after [Service_Start_Date] in the first line, that means, change
IF [SERVICE_START_DATE]) <=

to 

IF [SERVICE_START_DATE] <=

Let me know if it works for you.

Best,

Roland

[Bennel_Wilson]

Hi,

The way I'm reading the formula, in the first line, you've used a closing parenthesis after "[Service_Start_Date])" there is no opening parenthesis for that.

Correct that and let me know if that solves your problems.

If this helps, kindly mark it as solution

Regards

Benn

[lynnaberry]

Thank you for your help Roland! I removed it and now I get this error.

[RolandSchubert · Accepted solution]

Change [SERVICE_START_DATE] < 01-01-2020 to

[SERVICE_START_DATE] < DateTimeParse('01-01-2020', '%d-%m-%Y')

I assume, all other fields are of data type "DATE"?

[lynnaberry]

Yes that worked @RolandSchubert ! Thank you very much!