Offers - Doing calculations with date attributes

[nathankebede]

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 

[maggod · Accepted solution]

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_]

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.

[adobechat]

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