Hi All,
Is there any function that returns the last date of the current year
Thanks in Advance
Discussion posts and replies are publicly visible
date(year(today()), 12, 31)
Won't it always be 31st December?
Thanks Sanchit
Yes . But i was afraid to go with the hard coded value
Put the value in a constant. You can name it meaningfully e.g. XXX_LAST_DATE_OF_CURRENT_YEAR so your code is readable, and you can reference it in multiple places. It's never not going to be 13st December so, yes it's a fixed value but bets practice is to put into a constant.
I'd suggest wrapping it in an expression rule. Thus if better functionality becomes available it can be swapped out. Also depending on the desires of the designer, different parameters can be used to make it behave differently (i.e. pass in a year, or an arbitrary date, to get the corresponding EOY date value, etc...)