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
7 - Meteor

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
7 - Meteor

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

 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels