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
Solved! Go to 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