I'm hoping this is a obvious/simple solution.
I am trying to do some rough forecasting which looks at a date 90 days after the ticket is solved. I'd like the attribute to behave like a date attribute where I can apply ranges or ideally even split into weeks and months, however, I know the latter requires extra work.
Here is my code so far and I'm stumped as to why it's not appearing as a date.
DATE(DATE_FORMAT(DATE_ADD([Ticket solved - Date], "day", 90), "yyyy-MM-dd"))
Please sign in to leave a comment.