Date Filter

[krunal]

Hi ,

I wants to show last year same month data in report studio,
so will be filter condition?


Thanks

[BigChris]

Is your data relational or dimensional?

[hespora]

Code Select Expand


[whateveryourdatefieldiscalled] between
_first_of_month(_add_years(current_date,-1)) and _last_of_month(_add_years(current_date,-1))


in case of relational.

[krunal]

my report is relational

Thanks Hespora,

[hespora]

you're welcome; glad I could help :)