Is there a way to easily replicate the DATE_TRUNC SQL function? Example
I have SQL background and I have been using that formula very regularly when it comes to group by dates.
For example, if I wanted to do the date_trunc up to the month on a date column from an excel, I would have to extract year, month and days, then multiply days * -1 and add 1, then do a date diff from the original date with those days. It feels a bit indirect, but I might be wrong. Any suggestions?