Last 45 days filter

[MSTRTD]

How to calculate the last 45 days from current date in a filter
thanks

 

[SteveGilles]

Syntax dependant on your back-end database, but use an applysimple to filter the daterange

 

[kpescatore]

An easier solution may be to use the a dynamic date in your filter

 

[MSTRTD]

My back end is Teradata.
I was using
ApplyComparison ("#0 >= (select max(dte_key_num)-45 from views.time_detail from refrnc_dte < current_date ) AND #0 <=(select max(dte_key_num) from views.time_detail from refrnc_dte < current_date )", Date@[Date Key Num])

buts its not working.

Thanks

 

[kpescatore]

I haven't tested this but it looks like you have a "from" in place of a "where"

ApplyComparison ("#0 >= (select max(dte_key_num)-45 from views.time_detail from refrnc_dte < current_date ) AND #0 <=(select max(dte_key_num) from views.time_detail from refrnc_dte < current_date )", Date@[Date Key Num])

 

[wolf5370]

Agree with kpescatore, as you are using Current Date, then use dynamic dates. Current date - 45 days. Simple. It will make for more efficient SQL too as you will get a "DateField = 'ccyy-mm-dd' clause rather than a subquery.

I would only use the Applysimple here if youyr date table is not matching your current date - i.e. you plan to run after midnight and still call yesterday, today (and today's date is the latest value on the date table).