Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
now contains time as well.
floor it to show only date
num(floor(now()))
or use today()
now contains time as well.
floor it to show only date
num(floor(now()))
or use today()
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')
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
Many thank's Ioannis 😉