topic SQL Query custom expression - date range in Discussions

SQL Query custom expression - date range

Phil_Nash — Sat, 10 Jun 2023 20:52:02 GMT

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?

Re: SQL Query custom expression - date range

ErraticAttack — Wed, 10 Aug 2022 15:10:24 GMT

Try using

SYSDATE - 180

Re: SQL Query custom expression - date range

Phil_Nash — Wed, 10 Aug 2022 15:29:10 GMT

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)

Re: SQL Query custom expression - date range

Georg — Fri, 12 Aug 2022 09:37:50 GMT

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.