Subtract 1 year from the current date 1

[rharness]

I think what I want to do is simple, yet I still can't figure it out on my own.

Using Crystal Reports 10, I'd like to grab registration_style_view.Start_Date records that are exactly one year prior to whatever the current date is.

If this is do-able, does anyone have any tips/suggestions on how I could go about it?

Thank you!
-Roger Harness

 

[dgillz]

Dateadd("yyyy",-1,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

 

[rharness]

dgillz,

Thank you for the formula!

I feel dumb, but I'm still learning to deal with forumlas.

Where exactly should the formula be placed? I'd like to use the modified date in the select expert, as well as placing it on the report.

Thank you again dgillz,
-Roger Harness

 

[rharness]

dgillz,

Nevermind my last message, I think I got it!
(Formula Fields > New > Formula Name > Formula Workshop)

Your formula worked perfect.

Thanks again,
-Roger Harness