Hello,

I'm using Crystal Reports 2013 Support Pack 1
Version 14.1.1.1036

Last year I had a formula that worked perfectly for us. which is:

{@prod date} = (yeartodate)

but since we're in January now, the report is bringing very little data back since we're still in the 3rd day.

What I need is a formula that always looks at the last 365 days to current date or to current date -1.

Thank you,

Basel.

you could also probably use something like:
{@prod date}>dateadd("y",-1,today)

probably a host of other ways as well