Solved

What is wrong with this

Posted on 2015-01-20
3
116 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Reports--SubReport 3 52
Changing Image in report header based on parameter value 12 54
Crystal Reports Date Calculation 10 38
Crystal Reports No Record Returned 2 51
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

815 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now