In date picker element how can we select the date 30 days from the selected date

In date picker element how can we select the date 30 days from the selected date. For eg - I have 2 date picker elements and i want to filter the leads on the basis of date, I select date 1.1.2024 in first element then i should be able to select the date till 31.1.2024 in second date picker element (For 1 month only )

Hi @Akshit_Gupta thanks for posting the question on Vahana Community.

You can find the following solution helpful:

  1. Select END DATE TYPE as dynamic
  2. Use the formula DATE(STATIC(30D, String))

Please note that the number can be positive or negative as well. DATE(STATIC(-30D, String))

image

1 Like