Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Navigator
6 - Meteoroid

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

1 REPLY 1
LindaT
Alteryx
Alteryx

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

Labels