Date formula working on a parameter 1

[AlanCrawford]

Hi guys,
Quick question for you... Is it possible to calculate a date which is exactly 8 weeks before a date parameter?

I know that Crystal has various built in date range functions - but what I would like is the specific calculated date.

Thanks in advance for any help you can give me,

Alan Crawford
Sx3

 

[IdoMillet]

Try:

DateAdd("ww", -8, {your_date_field})

Cheers,
- Ido

ixm7@psu.edu

 

[AlanCrawford]

Thanks Ido. I actually figured out a way immediately after I posted:

//Simply works out the date 8 weeks before the 'Requested From' variable.
WhilePrintingRecords;
DateVar EightWeeksBeforeRequestedFrom;
EightWeeksBeforeRequestedFrom := ({?Requested From} - 56)

... but thank you very much for replying! It's very much appreciated. )

Best Wishes,

Al.