topic Re: Based on current date i want next 3 years date as end date in Dashboards & Analytics Discussions

Based on current date i want next 3 years date as end date

KHK — Wed, 07 Jun 2023 12:08:12 GMT

Hi Team,

I have one requirement.

In my dashboard i have date prompt filter, that filer is current date of transaction date to next 3 years of transaction date, i.e 6/7/23 -6/6/26.could you let me know how to achieve this dynamically.

This date range change every day in dashboard filter.

Re: Based on current date i want next 3 years date as end date

JoeM — Wed, 07 Jun 2023 13:18:54 GMT

@KHK - Check out this article which showcases how to use dynamic date filtering through presentation variables. Let me know if you have any more questions along the way.

Re: Based on current date i want next 3 years date as end date

RADSr — Thu, 08 Jun 2023 01:44:24 GMT

Do you mean that you want 1095 values to show up in a prompt list?

Or that you don't want a prompt at all, but do want a rolling three years future data included in the dashboard?

A few things:

The article Joe mentions is good for filtering dates dynamically based on an input date
Another approach is to use session variables for date targets ( e.g. today + 30, today + 90, etc. )
^^ shameless ask -- please "kudo" this product idea: https://community.incorta.com/t5/product-ideas/allow-declaration-of-data-type-for-session-variables/idi-p/2245
Using session variables will minimize the formula code dashboard authors will need to write.