Can we use date functions in the Expression Builder

[SilvioC]

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.

[garrettchung · Accepted solution]

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.