Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am using Nprinting 17 for reporting.
I have a variable in my report.
vDateToApply.
This will get the yesterday's date on daily refresh.
Sometimes , the refresh won't happen because of db refresh issue. So, this variable will not get the latest Yesterday's date.
To check that, I am creating nprinting report to show the vDateToApply value to Admin by sending the mail from NPrinting.
But the Admin don't need this mail on successful refresh. Whenever this date don't have the latest "Yesterday's date", they should get the mail.
To achieve this, i created one condition in Nprinting.
vDateToApply=07/24/2018
I given the expression as below but it is showing false. Please tell me the right way of writing the expression.
Thanks in advance.
Regards
Srinivas
May be use like this:
=text(date( today()-3 , 'MM/DD/YYYY'))
or
=text(date( today()-3 , "M/DD/YYYY"))
May be use like this:
=text(date( today()-3 , 'MM/DD/YYYY'))
or
=text(date( today()-3 , "M/DD/YYYY"))
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
hope this helps
cheers
Lech