How to format date time to specify the time

0
Hi all,   I’ve a variable that calculates the 31st of December of the current year. However the time is set at 00:00 when I’d like to set it at 11:59:99. At the moment the way I’m doing it is by having change variables to add seconds, minutes, and hours but I was wondering if I could do it all on this one variable that you see in the image above. Any one have any ideas?   Kind regards Nathan
asked
2 answers
1

Doesn’t this work:

parseDateTime(‘31-12-’ + $CurrentYearInt + ‘ 23:59:59’, ‘dd-MM-yyyy hh:mm:ss’) ?

Otherwise set the date to January 1st  of the next year and subtract 1 second?

answered
0

Why do it so difficult. Just use the token [%EndOfCurrentYearUTC%] or [%EndOfCurrentYear%].

Regards,

Ronald

 

answered