nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Query custom expression - date range

Phil_Nash

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

Accepted answers

ErraticAttack

Try using

SYSDATE - 180

All comments

ErraticAttack

Try using

SYSDATE - 180

Phil_Nash

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)

Georg

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.