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

Offers - Doing calculations with date attributes

  • March 21, 2023
  • 3 replies
  • 1097 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     Find me on LinkedIn
adobechat
Level 5
March 28, 2023

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