NPrinting Date filter Problem

[ecabanas]

Hi,

I'm creating a filter in a date field, I would like to show the items sold yesterday and the formula in the filter is:

=num(now()-1,'#####')

the dateformat in Qliview is numeric yesterday= 42163

and the report did not recognize the date

Thank's in advance

Eduard

[giakoum · Accepted solution]

now contains time as well.

floor it to show only date

num(floor(now()))

or use today()

[avinashelite]

hi,

dont use now it has time associated with it. Try with today()  and keep the variable and column date format same .

Date(today()-1,'DD-MM-YYYY')

[Anonymous]

You can also create a variable in the application and call that filter to NPrinting which is one of the easiest way.

It happened to me in one of the application

[ecabanas]

Many thank's Ioannis  😉