Date Formula - YTD complete month compared to same period last year

[socalvelo]

CR 11
Oracle Server

I need to compare values this year YTD though last complete month to the same period last year.


I'm having trouble writing the date range formula for last year. I would need it to cover LastYearYTD to the last day of the matching complete month last year (13 months ago?).

Thank you

Ed

 

[lbass]

Use a record selection formula like this:

(
{Table.date} in date(year(currentdate),1,1) to date(year(currentdate), month(currentdate),1)-1 or
{table.date} in date(year(currentdate)-1, 1,1) to date(year(currentdate)-1,month(currentdate),1)-1
)

You can use the same language in conditional formulas, e.g., if {table.date} in ...then {table.amount}, etc.

-LB

 

[socalvelo]

Thank you LB. Worked perfect.