Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

how to get the last date of the year

sn2200
8 - Asteroid

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!

3 REPLIES 3
Dina
9 - Comet

This should work.

Dina_0-1682440070392.png

 

sn2200
8 - Asteroid

how can i get the result without the date field.

Dina
9 - Comet

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.

Dina_0-1682440796515.png

 

Labels
Top Solution Authors