Field Added to Data Source - Formula Only Look Between Specific Dates

[glennlooker]

Hello All, a conversion source in Google Ads changed and I wanted to only pull a formula rule between a specific date range:

• Start Date: September 1, 2022

• End Date: January 31, 2023

What I'm trying to achieve is use that formula only between September 1, 2022 and January 31, 2023 and then use the below for any date starting February 1, 2023 and forward

My Current Formula that's segmenting conversions is that I want from September 1, 2022 - January 31, 2023:

CASE
WHEN CONTAINS_TEXT(Segment Conversion Category, "Contact") THEN "Bookings"
ELSE "Other"
END

The New Formula that I want is below for February 1, 2023 and forward.

CASE
WHEN CONTAINS_TEXT(Segment Conversion Category, "Contact") THEN "Phone Calls"
ELSE "Other"
END

Achievable? Not achievable? Thank you in advanced 🙂