Dates from Last Year 1

[jonbarr]

I want to show transactions that occured in a set time frame last year with a start date of exactly a year ago, and a parameter of a number of days up to 180 after that date. I imagine the formula would look something like
Currentdate - one year + (number of days from parameter)

Can anyone please help with such a formula
Thank you

 

[jonbarr]

Sorry, using CR ver 8.0 with SQL 2000

 

[vidru]

You can get creative with some of the built-in date range functions. For example:

Maximum(LastYearToDate)

... will give you today's date minus one year. If you have a parameter field like {?NumDays}, to get your desired result would look like:

Maximum(LastYearToDate) + {?NumDays}

-dave

 

[jonbarr]

Thanks Dave, that was exactly what I wanted

 

[lbass]

Try:

{table.date} in dateadd("yyyy",-1,currentdate) to
dateadd("d",{?NoDays},dateadd("yyyy",-1,currentdate))

-LB

 

[jonbarr]

Thanks for your suggestion lbass.

I found Dave's idea worked well except the correct syntax in Ver 8.0 turned out to be "maximum (LastYearYTD)

 

[vidru]

jonbarr:
I think that was just a case of the brain not working with the hands on my part.

LB's formula would also work, but I can never remember if there are issues with pass-through when using Date functions (like DateAdd), so I find myself avoiding them in record selection formulas.

-dave