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

Offers - Doing calculations with date attributes

  • March 21, 2023
  • 3 replies
  • 1094 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

adobechat
New Participant
March 28, 2023

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

_Manoj_Kumar_
New Participant
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
mdonkeAccepted solution
New Participant
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.