Re: How to create the date expression in Nprinting 17 Conditions
As always there 2 sides of equation. So you have your variable and your expression.
I agree with Bala that it is important to bring both sides of equation to the same data type - in your case it is likely to be text, but
there are 2 things you can do to check why it is not working
check how NPrinitng is understanding your variable by exposing it in a temporary report (for example by adding it to excel template and previewing it)
It might be that your variable is not evaluating and therefore is not returning value (or rather returning Null())
The last thing you might do is to convert your variable value to number by applying floor function on your variable value definition. This will remove any text/date format issues as well as potential timestamp/decimal part issue
keep in mind that the floor function should be applied when defining variable as well as in your expression in NPrinitng =Floor(today()-3 )
hope this helps
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.