topic Re: Dynamic date range in Dashboards & Analytics Discussions

Dynamic date range

KHK — Thu, 06 Jul 2023 17:56:59 GMT

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 — Thu, 06 Jul 2023 18:28:25 GMT

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

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

RADSr — Thu, 06 Jul 2023 23:28:50 GMT

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 — Fri, 07 Jul 2023 15:25:39 GMT

HI,

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

KHK — Fri, 07 Jul 2023 15:26:35 GMT

Hi,

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

anurag — Fri, 07 Jul 2023 15:58:49 GMT

You can filter it using between function:

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

KHK — Fri, 07 Jul 2023 16:09:23 GMT

Hi Anurag,

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

anurag — Fri, 07 Jul 2023 21:55:33 GMT

Try this formula @KHK

between(

< schema.table.date > ,

addMonths($currentYearStart,-3),

monthEndDate(addMonths($currentYearStart,9))

)