Crystal 6.0, I have a field {WORKORDER.REPORTDATE}and another field @Date that gives me a number. How can I add the 2 fields together to increase the {WORKORDER.REPORTDATE} by the amount of days stated in the @date field.
I tried
if {@Days} = "1" then
{WORKORDER.REPORTDATE} + 500 else
If {@Days} = "2" then
{WORKORDER.REPORTDATE} + 365 else
If {@Days} ="3" then
{WORKORDER.REPORTDATE} + 180 else
If {@Days} ="4" then
{WORKORDER.REPORTDATE} + 56 else
if {@Days} = "5" then
{WORKORDER.REPORTDATE} + 28 else
If {@Days} = "6" then
{WORKORDER.REPORTDATE} + 14 else
if {@Days} = "7" then
{WORKORDER.REPORTDATE} + 7 else
if {@Days} = "8" then
{WORKORDER.REPORTDATE} + 2 else
If {@Days} = "9" then
{WORKORDER.REPORTDATE} + 1
but the field always stays blank no matter what. TIA
I tried
if {@Days} = "1" then
{WORKORDER.REPORTDATE} + 500 else
If {@Days} = "2" then
{WORKORDER.REPORTDATE} + 365 else
If {@Days} ="3" then
{WORKORDER.REPORTDATE} + 180 else
If {@Days} ="4" then
{WORKORDER.REPORTDATE} + 56 else
if {@Days} = "5" then
{WORKORDER.REPORTDATE} + 28 else
If {@Days} = "6" then
{WORKORDER.REPORTDATE} + 14 else
if {@Days} = "7" then
{WORKORDER.REPORTDATE} + 7 else
if {@Days} = "8" then
{WORKORDER.REPORTDATE} + 2 else
If {@Days} = "9" then
{WORKORDER.REPORTDATE} + 1
but the field always stays blank no matter what. TIA