Expand my Community achievements bar.

The 2nd edition of the Journey Optimizer Community Lens newsletter is out now!
SOLVED

Offers - Doing calculations with date attributes

Avatar

Level 1

Hi all, 

 

I'm researching the possibility of doing calculations with date attributes in AJO (PQL), such as creating a dynamic variable (parameter) for days left until a specific day (use case ex. = expiration date). I've found the documentation for "date and time functions" and "arithmetic functions", but am I able to apply these arithmetic functions directly to date attributes or is there some preliminary conversion that needs to be made to the dates? 

 

Specific use case: date difference ((date_1 + XX days)      ,      today)

 

Thanks in advance for any suggestions 😁

1 Accepted Solution

Avatar

Correct answer by
Level 4

Probably same topic as here

I'm not aware of a solution.
You may want to raise an idea so that Adobe considers implementing it.

3 Replies

Avatar

Correct answer by
Level 4

Probably same topic as here

I'm not aware of a solution.
You may want to raise an idea so that Adobe considers implementing it.

Avatar

Community Advisor

Hello @nathankebede 

 

There is no function available to make this calculation work. You can raise an idea for Adobe to consider it in the upcoming releases.

Avatar

Level 4

Can't do it at the moment, its a feature request.