Help with formula

[jlgjohnson]

I need to pull data from a pipeline report older than 6/1/04. How would that formula read?

{Pipeline_Opps.ModifiedDate} < ??????

Thanks for any help!

Jamie

 

[synapsevampire]

Try:

{Pipeline_Opps.ModifiedDate} < cdate(2004,6,1)

-k

 

[jlgjohnson]

Thank you for replying to this. It doesn't seem to be working. I am still getting ALL of the dates. I am sure that there is something that I am missing...I just don't know what it is yet.

 

[kskid]

Post your record selection or formula that is using the expression

Also post more technical info

Crystal Version
Database and connectivity
Sample data
Expected output

-LW

 

[jlgjohnson]

I am trying to only pull from the database the records that are older than 6/1/2004 and that are not in the AWARDED field.

When I use this formula, I am still getting everything.


{Pipeline_Opps.Phase} <> "Awarded" or Remainder(RecordNumber,2) <> 0 and {Pipeline_Opps.ModifiedDate} < cdate(2004,6,1)

 

[kskid]

Then it should just be

{Pipeline_Opps.Phase} <> "Awarded" and {Pipeline_Opps.ModifiedDate} < cdate(2004,6,1)


What are you trying to accomplish with

or Remainder(RecordNumber,2) <> 0

 

[jlgjohnson]

Well, I have eliminated the "awarded" part of it and deleted that from the grouping.

I now only have {Pipeline_Opps.ModifiedDate} < cdate(2004,6,1) and it just isn't pulling the correct data.

the Remainder statement is because I have 2 Detail rows (a & b) and that helps me sort get them on the correct page. That works fine.

I just don't know why it isn't pulling the right data.

 

[synapsevampire]

I would suspect that it's pulling the right data, it's rare that it "makes things up".

Place the date field in the details section and display the report, do you see dates other than what is expected?

Perhaps they have a default date that's screwing you up?

-k

 

[lbass]

Can you explain what you're trying to do in a little more detail? What is your group field?

I wonder whether you are trying to identify groups that have NO "Award" at any time versus looking at those records which are <> "Award" within a group.

Also, are you trying to look at any records with a date less than 6/1/04 even if there is a later record, or are you trying to identify groups where the most recent record is less than 6/1/04?

-LB