SQL Query custom expression - date range

[#1]

I am trying to pre-filter a Query based on date range, but can't figure out how to get it to work.  I keep getting this error.  I have to be missing something simple, right?

JMP Query Error.PNG

 

[#2 · Accepted solution]

Try using

SYSDATE - 180

[#3]

I wasn't thinking that I needed to write it in SQL... d'uh.

This worked;

t4.Date >= CAST(DATEADD(DAY, -180, GETDATE()) as DATE)

[#4]

You Don't need to, but I really recommend this way, because it is easy and most effective. Btw I think you don't have to typecast the date, if database column is Set up correctly You can compare as date/number directly. Of course you can Do in JSL as well, but more complicated.