Whenever I create a table calculation or a custom dimension that should be in date format, it always comes out YYYY-MM-DD. Using trunc_months()
or trunc_years()
doesn’t not affect this: it still comes out YYYY-MM-DD.
An example of what I’m trying to do is trunc_months((add_months(1, ${account.created_month})))
This means that I can’t effectively merge off of these fields, if I’m looking to create a merge query based on monthly or yearly data.
I’d greatly appreciate any advice on how to get around this.