Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

NPrinting Date filter Problem

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

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

now contains time as well.

floor it to show only date

num(floor(now()))

or use today()

View solution in original post

4 Replies
giakoum
Partner - Master II
Partner - Master II

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
Not applicable

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
Creator II
Creator II
Author

Many thank's Ioannis  😉