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

How to create a date & time field using a Time (Only) field?

Topic Labels: Dates & Timezones
1156 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have Airtable integrated with a third party app, where all data collections automatically flow into Airtable.

Two main fields that get loaded into Airtable are a user-entered Date and Time. I’d like to create a third formula column in order to add these two together to get a Date & Time Airtable field.

Does anyone have any suggestions on the formula to use here? I’ve experimented for days with no success. Thanks in advance!

Screen Shot 2021-02-27 at 1.11.51 AM

1 Reply 1

Welcome to the Airtable community!

The exact formula will depend on the field types of the inputs. For example, the process will be different if your time is a text field versus a duration field.

If your time is a duration field, you can use DATEADD() to add the number of seconds in the duration field to the date.

If your time is a number field, you can use DATEADD().

If your time is a text field, you can use DATETIME_PARSE() in combination with DATETIME_FORMAT or DATESTR. It looks like this is the case, but it can be hard to tell because your {Time Test} is a formula field…

DATETIME_PARSE(
  DATESTR({Date Test}) & " " & {Time Test},
  "YYYY-MM-DD hh:mm"
)

All of these functions are documented in the formula field reference.