Can we use date functions in the Expression Builder | Community
Skip to main content
S
SilvioC
July 7, 2022
Solved

Can we use date functions in the Expression Builder

  • July 7, 2022
  • 1 reply
  • 855 views

Hi

is it possible to use dates functions in the Expression Builder? Do they exist in Audience Manager?

 

I try to explain my needs:

I have a signal with the year's born of customer: c_eVarX = "1980"

I want to create traits/segments for different age-range. For instance: 18-25, 26-35, 36-45, etc..

 

Is it possible to build a formula like this:

(c_eVarX <= (today(Y)-18)) AND (c_eVarX >= (today(Y)-35))

instead of:

c_eVarX <= 2002 AND c_eVarX >= 1987

 

The second formula works, but I have to update it every year.

 

Best regards,

s.

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by gchung

There is no way to do calculations with the Trait Expression. Your best option to the create Traits from individual birth years and age bands as you have done above.

 

You will then have the flexibility of adjusting the ages at the Segment level. This will also avoid updating Traits or Segments.

 

1 reply

G
Adobe Employee
gchungAdobe EmployeeAccepted solution
Adobe Employee
July 30, 2022

There is no way to do calculations with the Trait Expression. Your best option to the create Traits from individual birth years and age bands as you have done above.

 

You will then have the flexibility of adjusting the ages at the Segment level. This will also avoid updating Traits or Segments.

 

    Terms & ConditionsAccessibility statement

    Loading footer...