Skip to main content
New Member
March 21, 2023
해결됨

Offers - Doing calculations with date attributes

  • March 21, 2023
  • 3 답변들
  • 1131 조회

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 😁

이 주제는 답변이 닫혔습니다.
최고의 답변: 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 답변

mdonke답변
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.