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:
the dateformat in Qliview is numeric yesterday= 42163
and the report did not recognize the date
Thank's in advance
now contains time as well.
floor it to show only date
or use today()
Many thank's Ioannis ;-)
dont use now it has time associated with it. Try with today() and keep the variable and column date format same .
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
Retrieving data ...