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

[KHK]

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. 

[JoeM]

@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.

[RADSr]

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:

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