i want to setup a filter based on todays date -1
Why this doesnt work?
thanks in advance
May be this?
Or Can you provide more info
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 ......
May be these approaches
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)
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.
Date with your existing format : =Date(now()-1, 'DD.MM.YYYY')
Thanks, does exactly what i need
Was it the date format or the function?
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.
Retrieving data ...