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]

So next year starting Jan 1st, filter will be:

October 01/10/23 to 31/10/24 ?

[KHK]

Hi,

I need to get data from October 01/10/22 to 31/10/23

[anurag]

You can filter it using between function:

between(<schema.table.date>, date("2022-1-10"), date("2023-31-10"))

[KHK]

Hi Anurag,

Date have to change dynamically, next year data have to fetch between (01/10/2023 to 31/10/2024).