FORMULA FOR LAST 120 DAYS 1

[mamarockstar]

Hi,

I'm using Crystal Reports v.8. I have a report that shows a client's past appoinments in the last 90 days using the built-in "in over90days" date range function. What I need to know now is a client's past appointments in the last 120 days.

Is there a built in function for this or do I need a specific formula? I searched thru the date range functions and have not found one with "120days".

Thanks,
Dennielle

 

[dgillz]

{YourDateField} in CurrentDate to Dateadd("d",-120,CurrentDate)

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mamarockstar]

You're my hero! Thanks! It worked!

Life is easier now.........

 

[koolskins]

Crystal 10 against an Informix database... I have an inventory table with return transactions by date and a workorder status table where the workorder status is maintained by date. I am trying to show what the workorder status was at the time of the inventory transaction???

inventory workorder status and date

item1 3/21/2007 AA 2/1/2007
BA 2/21/2007
CA 3/31/2007

I need to show the BA status for this item code. As always your expert guidance would be much appreciated.

RW

 

[dgillz]

koolskins,

Please start a new thread.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry