I am trying to get the last date of the year - 3 so it will be dynamic. The formula result should be 12/31/2020. Can you help with the best way to get the result?
Thanks in advance!
This should work.
how can i get the result without the date field.
Yes. You can apply the formula to an existing field. For example, updating the existing filed "Date". If you need the last date for current year, you can use the formula DateTimeToday, which will automatically generate today's date.