Concatenate multiple fields if value is not null using IF

[MisterMo]

Hi guys

I am trying to buld a formula to display only fields with values, I remember in the past (V7), using the if statement with no problems. but for some reason I can't make it work anymore

this is the formula

stringVar x;
x := '' ;

if isnull({SPD.MonAMStartTime})= false then

x := x & 'Morning: ' & totext(time({SPD.MonAMStartTime})) + ' to ' + totext(time({SPD.MonAMEndTime}));

if isnull({SPD.MonPMStartTime})= false then

x := x & ' - Afternoon: ' & totext(time({SPD.MonPMStartTime})) + ' to ' + totext(time({SPD.MonPMEndTime}))

else
x := '';


If I have values on both fields or on the second field it works else it doesn't

Any Idea?

Thanks for your help




Life is like a box of Chocolates..... So is Microsoft

 

[Katy44]

Not sure if this is it, but try replacing

if isnull({SPD.MonAMStartTime})= false

with

if not isnull({SPD.MonAMStartTime})

 

[Katy44]

oh, and for the PMStartTime one too.

 

[MisterMo]

Sorry my mistake I have just realised the the Else part is compared with the last if statement.

so by changing the

x=''; to x;

it worked just fine



Life is like a box of Chocolates..... So is Microsoft