topic Re: Filter Date Today-1 in Qlik NPrinting

Filter Date Today-1

a1exand3r — Wed, 25 Sep 2019 18:40:54 GMT

Hello,

i want to setup a filter based on todays date -1

Why this doesnt work?

thanks in advance

Re: Filter Date Today-1

Anil_Babu_Samineni — Tue, 09 May 2017 12:46:33 GMT

May be this?

=Date(Today(1)-1)

Or Can you provide more info

Re: Filter Date Today-1

a1exand3r — Tue, 09 May 2017 12:50:49 GMT

I have dates in a table, so i only want to get the rows with the dates before today.

The Values are like 07.05.2017 ......

Re: Filter Date Today-1

Anil_Babu_Samineni — Tue, 09 May 2017 12:55:12 GMT

May be these approaches

1) Script

Load * from Table where DateField <= Date(Date#(DateField-1,'DD.MM.YYYY'),'DD-MM-YYYY');

2) From End May be this?

If(DateField <= Date(Date#(DateField-1,'DD.MM.YYYY'),'DD-MM-YYYY'), DateField)

Re: Filter Date Today-1

neelamsaroha157 — Tue, 09 May 2017 13:04:01 GMT

It looks like you are trying this expression in NPrinting.

If yes, then can you try with =Date(now()-1).

You can add the format if your date format is different from default.

Re: Filter Date Today-1

neelamsaroha157 — Tue, 09 May 2017 13:05:16 GMT

Date with your existing format : =Date(now()-1, 'DD.MM.YYYY')

Re: Filter Date Today-1

a1exand3r — Tue, 09 May 2017 13:11:36 GMT

Thanks, does exactly what i need

Re: Filter Date Today-1

neelamsaroha157 — Tue, 09 May 2017 14:02:11 GMT

Great..

Was it the date format or the function?

Re: Filter Date Today-1

a1exand3r — Wed, 10 May 2017 06:25:08 GMT

I think now() creates a date in Systemformat so i dont specify the format.

I used now() instead of Today() and it worked for me.

Re: Filter Date Today-1

Anonymous — Fri, 26 Oct 2018 11:17:51 GMT

I have the same issue but this solution is not working for me.

I tried with formatting and without formatting. but nothing works with date filter.

i have also tried formatting column in load and in the table. The column in database is of type - datetime

Re: Filter Date Today-1

a1exand3r — Mon, 05 Nov 2018 08:10:04 GMT

Replace "=Date(Today())" with "=Date(now(), 'DD-MM-YYYY')"