Gordon Hughes
asked on
What is wrong with this
I have a formula:
If isnull ({WO.COMPLETIONDATE}) or ({?Completion Date Cut Off} < {WO.COMPLETIONDATE}) then 'Not Completed before Completion Date Cutoff' else {WO.COMPLETIONDATE}
It has an error saying a string is required at the else {WO.COMPLETIONDATE} what have i got wrong?
Gordon
If isnull ({WO.COMPLETIONDATE}) or ({?Completion Date Cut Off} < {WO.COMPLETIONDATE}) then 'Not Completed before Completion Date Cutoff' else {WO.COMPLETIONDATE}
It has an error saying a string is required at the else {WO.COMPLETIONDATE} what have i got wrong?
Gordon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Understand
ASKER
Have used an alternative in text form
But understand and agree with what you say
Gordon