Dynamic date range

[KHK]

Hi,

i want to run my report for every year previous year October 1st to current year October 31st.I.e 01/10/22 to 31/10/23.

could you please let me know how to write formula

[anurag]

Try this formula @KHK 

between(

< schema.table.date > ,

addMonths($currentYearStart,-3),

monthEndDate(addMonths($currentYearStart,9))

)

[RADSr]

This sounds like a job for a fiscal calendar.   ( I'm guessing it's a fiscal calendar, but even if not, it's a job for a specialized calendar ).     

[KHK]

HI,

Yes i am using Fiscal Year in the formula to get data from previous year October 1st to this year October 31st.