Crystal Reports if then, variables and dates

Question

I need to create a crystal formula to look for a specific number in a record, if that number exist then create a date/time variable. Look for a second record with a different specific number and create a second date/time var. Then calculate a date diff between the two var. Im new to crystal and am stumped any help would be appreciated. this is what I have and it obviously does not work. "EVNT_CD" 10 will always be a start date and "EVENT_CD" 11 will always be the end date. thanks dave

IF {WKWOEVENTS.WE_EVNT_CD} = 10
then local DateTimeVar d1 := {WKWOEVENTS.WE_EVNT_DT}+{WKWOEVENTS.WE_EVNT_TM}
IF {WKWOEVENTS.WE_EVNT_CD} = 11
then local DateTimeVar d2 := {WKWOEVENTS.WE_EVNT_DT}+{WKWOEVENTS.WE_EVNT_TM}
DateDiff ("h",d1,d2)

Couple of questions: Is the "10" a part of {WKWOEVENTS.WE_EVNT_CD} or is it the full value? Is {WKWOEVENTS.WE_EVNT_CD} a string or a number? — campagnolo_1, Nov 26 '13 at 17:11
{WKWOEVENTS.WE_EVNT_CD designate the event type. 10 = event start and 11 = event end. Im hoping to display the difference in hours. — user3037403, Nov 26 '13 at 17:21

score 0 · Answer 1 · answered Nov 26 '13 at 17:30

I would break this up into 3 separate formulas:

1)

IF {WKWOEVENTS.WE_EVNT_CD} = 10
then shared DateTimeVar d1 := {WKWOEVENTS.WE_EVNT_DT}+{WKWOEVENTS.WE_EVNT_TM}

2)

IF {WKWOEVENTS.WE_EVNT_CD} = 11
then shared DateTimeVar d2 := {WKWOEVENTS.WE_EVNT_DT}+{WKWOEVENTS.WE_EVNT_TM}

3)

shared DateTimevar d1;
shared DateTimeVar d2;
DateDiff ("h",d1,d2)

Breaking this up into 3 formulas brings the need to change the variables from local to shared. You will also need to make sure to put the formulas in the correct order. The 3rd formula needs to be positioned so it gets evaluated After formula 1 and 2. You might get an error if {WKWOEVENTS.WE_EVNT_DT} and {WKWOEVENTS.WE_EVNT_TM} are not the right data format.

Crystal Reports if then, variables and dates

1 Answers1