Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Adding variable hours to a date

Topic Labels: Sync
239 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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)}?