Help

Re: Adding variable hours to a date

483 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kshitiz_Hamal
4 - Data Explorer
4 - Data Explorer

I am trying to add hours to a created date to get the due date of the project. First I tried this,``

DATEADD({Created On},{SLA (Internal)}),‘hours’)
For this, if I am adding 64 hours to a Created on date 07/29/2021 4:16 pm the results I am getting is 07/29/2001 9:15 pm. As this is not the result I am looking for, I tried the below formula which I got from the airtable help forum, but it doesn’t seem to work either. Totally new to Airtable.

DATETIME_PARSE( DATETIME_FORMAT( DATEADD({Created On}, CONCATENATE(’+’,{SLA (Internal)}),‘hours’) ,‘M/DD/YYYY h:mm’))


1 Reply 1

Welcome to the community, @Kshitiz_Hamal! :grinning_face_with_big_eyes: What type of field is {SLA (Internal)}?