The Community will be undergoing maintenance on Saturday January 11 at 11:59pm - Sunday January 12 at 11:59pm EST. For assistance during this time, please visit our Help Center.
Producing a due date through combining a "date" field and an "integer"
Hi All
Please see the attached screenshots which elaborate on the problem.
I have the following 3 columns:
Date Assigned:
Contains the following formula…
DATETIME_FORMAT(SET_TIMEZONE(CREATED_TIME(), ‘Asia/Dhaka’), ‘DD-MM-YYYY HH:mm’)
Time Allocated for Task (Days) -
This integer is being pulled in by a “lookup” value which you can see in the attached field
Due Date -
I tried to use the following formula to get add up the 2 above fields but this doesn’t seem to be working correctly.
You can see that it’s not working through looking at the screenshot…the due date is no different to the “assigned date”, even after
