Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

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
0
GiaHughes
Asked:
GiaHughes
  • 2
1 Solution
 
vastoCommented:
you need to convert the date to string

use ToText({WO.COMPLETIONDATE})
0
 
GiaHughesAuthor Commented:
OK

Have used an alternative in text form
But understand and agree with what you say

Gordon
0
 
GiaHughesAuthor Commented:
Understand
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now