Convert date to Qtr year

LDeniz — Tue, 13 Aug 2024 09:05:19 GMT

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?

Re: Convert date to Qtr year

karstenkoehler — Tue, 13 Aug 2024 09:22:32 GMT

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

topic Convert date to Qtr year in Tips, Tricks & Best Practices

Convert date to Qtr year

Re: Convert date to Qtr year