Solved

What is wrong with this

Posted on 2015-01-20
3
120 Views
Last Modified: 2015-01-20
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
Comment
Question by:GiaHughes
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
vasto earned 500 total points
ID: 40559875
you need to convert the date to string

use ToText({WO.COMPLETIONDATE})
0
 

Author Comment

by:GiaHughes
ID: 40559904
OK

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

Gordon
0
 

Author Closing Comment

by:GiaHughes
ID: 40559907
Understand
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question