Solved

Formula Error

Posted on 2014-09-30
9
147 Views
Last Modified: 2014-10-01
I am trying to suppress a section where the date is not equla to 01/01/1900

What is wrong with this
({WO.CLOSEDATE}) <> Date (1900,01,01)

Gordon
0
Comment
Question by:GiaHughes
  • 5
  • 4
9 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40353052
Is CloseDate a DateTime?

Try this

Date({WO.CLOSEDATE}) <> Date (1900,01,01)


Are you getting an error or just not working?

DO you need those records in the report for some reason?
If not why not just filter them out?

mlmcc
0
 

Author Closing Comment

by:GiaHughes
ID: 40353450
Very good as usual
0
 

Author Comment

by:GiaHughes
ID: 40353544
Hi mimcc

Thought it was ok said No Errors unfortuneatly when I try and run the report it says
error in file <selection_Visibility>.
Date({WO.CLOSEDATE}) <> Date (1900,01,01)
Bad date format string

Gordon
0
 

Author Comment

by:GiaHughes
ID: 40353550
Hi mimcc
if i change the formula to ({WO.CLOSEDATE}) <> Date (1900,01,01)

it says a string is required here

Gordon
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Expert Comment

by:mlmcc
ID: 40353649
Apparently your dates are really strings.  

Check the format/ value and change the selection to

({WO.CLOSEDATE}) <> "01/01/1900"

mlmcc
0
 

Author Comment

by:GiaHughes
ID: 40354197
Hi mimcc

I think we are on the correct line
but it does not work in the programme
I am trying to suppress a section when the WO.CLOSEDATE is not equal to 01/01/1900
in the database the data is shown as 1900-01-01 00:00:00.000

it does not seem to affect the report which appears to suppress the section regardless

Gordon
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40354582
Is the field a DATE or a STRING?

Drop the field on the report (if it isn't already)
Right click it
Click FORMAT FIELD
Do you see the NUMBER or DATETIME tabs?

mlmcc
0
 

Author Comment

by:GiaHughes
ID: 40355351
Hi mimcc

Dont see Number or datetime tabs
In crystal reports it says it is String [22]
but in the sql databse it says it is DATETIME

So totally confused

Gordon
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40355527
Try a VERIFY DATABASE

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

920 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

17 Experts available now in Live!

Get 1:1 Help Now