Hello. I'm using Crystal Reports 11.5 and have a question about displaying text in a formula. I don't have much experience with CR and it all seems quite confusing to me so any help is appreciated.
I have the following formula in my report:
if
{COMPLIANCEDATE.COMPLIANCEDATE}="immediately" then CurrentDate + 1
else if
{COMPLIANCEDATE.COMPLIANCEDATE}="3 days" then CurrentDate + 3
else if
{COMPLIANCEDATE.COMPLIANCEDATE} ="7 days" then CurrentDate + 7
else if
{COMPLIANCEDATE.COMPLIANCEDATE}="10 days" then CurrentDate + 10
else if
{COMPLIANCEDATE.COMPLIANCEDATE}="14 days" then CurrentDate + 14
else if
{COMPLIANCEDATE.COMPLIANCEDATE}="30 days" then CurrentDate + 30
else if
{COMPLIANCEDATE.COMPLIANCEDATE}="60 days" then CurrentDate + 60
else if
{COMPLIANCEDATE.COMPLIANCEDATE}="CUSTOM" then {NOTICE.CUSTOM_COMPLIANCE};
Currently, when I select "immediately" from the list I get tomorrow's date i.e. "01-27-11" from the CurrentDate +1 command.
What I want to display is the word "Immediately" when I select "immediately" instead. Is there an easy way to modify the formula so it displays this word/text instead of the date? All other selections should remain displaying the date (as they already do).
Just FYI, the "Custom" selection picks an arbitrary date that does not meet the +3, +7, +10, etc criteria.
Thanks in advance.
IP Logged
