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_years() doesn’t not affect this: it still comes out YYYY-MM-DD.
An example of what I’m trying to do is
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.