IF isnull({PMMilestonesWIP.EstPoscomplete}) then ''
else (if {PMMilestonesWIP.EstPoscomplete} = 1 then {PMMilestonesWIP.StakeEnd}
else {tblCustomers.Pos_Date})
I'm using this as a field in crystal reports and I can not get it to work.
I have tried this a dozen ways and I am running out of ideas.
It gives me errors with wanting strings or dates.