Date

[Cretin]

I am using crystal to report off of whats known as a heat database. The date is actually stored as a text string. Is what I am trying to do is develope a date formula that looks for all records over 90 days old. The 2 fields I use is currentdate and datereceived. So basically is what I need are all records where the difference between the date received and the current date is over 90 days. Any help would be appreciated.

 

[hilfy]

You say that the date is in a string format but you don't say what that format is... You can use the CDate function to convert pieces of the date string to a date, something like this:

CDate('11/06/2003') <= CurrentDate - 90

 

[Cretin]

That does look like it worked. Now I need to look up what cdate means so I understand what happened. I appreciate your help

Cretin

 

[synapsevampire]

Try creating a SQL Expression which Casts or Converts it as a date, and then do your comparisons against that, such as a record selection formula of:

{%RealDate} <= CurrentDate - 90

you'll get better performance, plus you'll have a real date field for use in the report.

-k