Convert date to Qtr year

[LDeniz]

Hi all, 

I want a custom property named "Renewal Qtr-Yr" that converts the reneal date i.e., 01/08/2024 to quater year format Q3 24.

Is this possible?

[karstenkoehler · Accepted solution]

Hi @LDeniz,

This can be achieved with a custom calculation property (type string), see below: https://knowledge.hubspot.com/properties/create-calculation-properties

concatenate((if((month([properties.createdate]) == 1), "Q1 ", if((month([properties.createdate]) == 2), "Q1 ", if((month([properties.createdate]) == 3), "Q1 ", if((month([properties.createdate]) == 4), "Q2 ", if((month([properties.createdate]) == 5), "Q2 ", if((month([properties.createdate]) == 6), "Q2 ", if((month([properties.createdate]) == 7), "Q3 ", if((month([properties.createdate]) == 8), "Q3 ", if((month([properties.createdate]) == 9), "Q3 ", if((month([properties.createdate]) == 10), "Q4 ", if((month([properties.createdate]) == 11), "Q4 ", if((month([properties.createdate]) == 12), "Q4 ", "Unknown"))))))))))))),number_to_string(year([properties.createdate])))

Simply replace the create date with your date property.

Best regards