how to get the last day of the year from date in variable?

[Anonymous]

Hi, I have a var that contains a date. lets say 15.7.2022 for example. How can I get the last day of the year based on that date?

15.7.2022 --> 31.12.2022
3.1.2021 --> 31.12.2021 

etc. 

[tackytechtom · Accepted solution]

Hi @Anonymous ,

How about this one:

DATE ( YEAR ( Table[Date] ), 12, 31 )

This one would give you:

15.7.2022 --> 31.12.2022
3.1.2021 --> 31.12.2021 (instead of 31.12.2022 as you stated in the question above though)

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Anonymous]

Thanks, works great 🙂