Offers - Doing calculations with date attributes | Community
Skip to main content
New Member
March 21, 2023
Solved

Offers - Doing calculations with date attributes

  • March 21, 2023
  • 3 replies
  • 1101 views

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 😁

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 mdonke

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

mdonkeAccepted solution
Level 4
March 21, 2023

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.

Manoj_Kumar
Community Advisor
Community Advisor
March 27, 2023

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.

Manoj  | https://themartech.pro
adobechat
Level 5
March 28, 2023

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