Expand my Community achievements bar.

Join us on September 25th for a must-attend webinar featuring Adobe Experience Maker winner Anish Raul. Discover how leading enterprises are adopting AI into their workflows securely, responsibly, and at scale.
SOLVED

Calculated Attributes - Function to Add days to a given date

Avatar

Level 2

Is there a function available in AEP  Calculated Fields  section, to add number of days to a given date ?
Currently found a manual workaround to fetch the date parts and convert a date into epoch timestamp and then add days to it. this process is complex and  lengthy. IS there a  function which I can leverage in calculated fields section  in AEP ?

1 Accepted Solution

Avatar

Correct answer by
Level 5
As per my Knowledge , AEP Calculated Fields do not support a built-in addDays() function. Currently, the only option is to manually convert the date to epoch, add days, and convert back—which is complex. Simpler date functions like addDays() are available in Adobe Journey Optimizer, but not in AEP Data Prep.
 
For now, you'll need to continue with the manual method or handle date arithmetic in downstream systems.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 5
As per my Knowledge , AEP Calculated Fields do not support a built-in addDays() function. Currently, the only option is to manually convert the date to epoch, add days, and convert back—which is complex. Simpler date functions like addDays() are available in Adobe Journey Optimizer, but not in AEP Data Prep.
 
For now, you'll need to continue with the manual method or handle date arithmetic in downstream systems.