Hello,
I have tried using a IF function in a crystal report but seem to be having problems getting the last part of the formula to work.
I'm trying to get the field to work so that if the date in the Updated Field {GL_CODE_LIST.Update} is the same date as that in the Created Field {GL_CODE_LIST.Created} then display some text otherwise return the field value {GL_CODE_LIST.Update}.
The formula is listed below,
IF ({GL_CODE_LIST.Created} = {GL_CODE_LIST.Updated} THEN "Code Not Updated" ELSE {GL_CODE_LIST.Updated})
I can get this formula to work in Excel no problem but I ideally want this to work in the Crystal Report before it's run.
I have set up four formulas in the report, detailed below
Formula1 - {GL_CODE_LIST.Created}
Formula2 - {GL_CODE_LIST.Updated}
Formula4 - IF (
{@Formula3} = 0 THEN "Code Not Updated" ELSE {GL_CODE_LIST.Updated})
So far this hasn't worked either. Every time I have done this it suggests that the final part of the formula has not been defined correctly.
I'm sure that this is really simple and doesn't take much to correct, but some advise or guidance would be greatly appreciated?
Thanks
Mark Platts