Question

Format date result of table calc/custom dimension as YYYY or YYYY-MM

  • 16 May 2022
  • 0 replies
  • 93 views

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.


This topic has been closed for comments