Issues with writing a boolean formula in In-Db formula tool

[Navigator]

Hi

I'm struggling with this in-db formula DATEDIFF(day,"MAX_SETTDATE",GETDATE()) < 5 which should result in either true or false.

I get the following error " incorrect syntax near '<' ", does anyone know the solution?

thanks

Anton

[LindaT · Accepted solution]

Hi Anton,

You would need to use a CASE statement to get that formula into column.

 CASE WHEN DATEDIFF(day,"MAX_SETTDATE",GETDATE()) < 5 THEN 1 ELSE 0 END

Thanks

Linda