I would like to have a function that returns the standard date filters (first and last day of the month, first and last day of the quarter, last day of the quarter and year). I have managed the month ones, but when trying to complete the year ones, I have a problem. I have an input variable called "year" and when run, the year is set to 2024. However the Create Variable function as shown below, returns 31/12/2025 23:59:59.
Any ideas what I am doing wrong?
Thank you!