This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's exciting to solve this and the going through the solutions other have posted so I can learn new tools!!!
Here's my solution anyways :)
I know I can do all of this in one formula expression, just finding working with dates a bit finicky compared to what I'm used to in SQL. But this didn't take too long!
Here's my solution. I used the formula tool and date-time tool.
This is very simple
This was a good one where I've become a huge fan of @Kenda DateTime macro...
Lesson learnt. To focus on DateParseFunction...
I basically did what the function does except in more steps...