Help

Producing a due date through combining a "date" field and an "integer"

Topic Labels: Dates & Timezones
665 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Darius_Safavi
5 - Automation Enthusiast
5 - Automation Enthusiast

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 afterScreenshot 2020-01-01 at 17.56.31 Screenshot 2020-01-01 at 17.59.35 I’ve tried to add the “10 days”.

0 Replies 0