Expand my Community achievements bar.

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.

View solution in original post

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.


     Manoj
     Find me on LinkedIn

Avatar

Level 5

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