Basic New User Question on "if then else" 1

[Yustrn]

Hello,

A little background, I'm a basic user that needs help fast. What I need to do is over my head. If you can help me I sincerly appreciate it.

A person at my job wrote a custom report, but has since left and I need to modify something that he has done. I am using Crystal 10 and what is happening here is I am getting two separate lines on my report for the same string of data, I know why this is happening, but what I need to be able to do is to say if the Date equals 8/31/06 for this particular field then replace that with the word "DELETE" normally I could fiqure this out, but there is already a huge filter being applied so I don't know exactly where to modify it.

//if isnull({PS_AWARD_SCHEDULE.VEST_DATE_1}) then
//totext("00000000")
//else if {PS_AWARD_SCHEDULE.VEST_DATE_1} < {@As of Date-1} then
//totext("00000000")
//else if {PS_AWARD_SCHEDULE.VEST_DATE_1} > {@As of Date-1} then
//ToText({PS_AWARD_SCHEDULE.VEST_SHARES_1},"00000000")

//*********Modified on 04/26/2006

if ({PS_AWARD_SCHEDULE.VEST_DATE_1} < {ROTPersonnelSummary.Option Date} AND datediff('m',{PS_AWARD_SCHEDULE.VEST_DATE_1},{ROTPersonnelSummary.Option Date}) > 48) then
totext("00000000")
else
ToText({PS_AWARD_SCHEDULE.VEST_SHARES_1},"00000000")

Where can I insert the modification and if you can tell me what I should put in there it would save me a ton of time.

 

[hilfy]

Try placing it just prior to the Else:

if ({PS_AWARD_SCHEDULE.VEST_DATE_1} < {ROTPersonnelSummary.Option Date}  AND datediff('m',{PS_AWARD_SCHEDULE.VEST_DATE_1},{ROTPersonnelSummary.Option Date}) > 48) then
'00000000'
else if ({PS_AWARD_SCHEDULE.VEST_DATE_1} = Date('2006', '08', 31) then 
'DELETE'
else
ToText({PS_AWARD_SCHEDULE.VEST_SHARES_1},"00000000")

Notice that I also changed totext("00000000") to '00000000' - you don't need ToText to convert a string to a string.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.