Help

Problems trying to Paste into "Date" field that "Includes time"

Topic Labels: Dates & Timezones
140 2
cancel
Showing results for 
Search instead for 
Did you mean: 
M_L
7 - App Architect
7 - App Architect

I'm attempting to paste Date and Time information into an Airtable "Date" field which has the "Include time" option checked. But, when I paste Date and Time information, it all goes in the "Date" part of the cell, and none of the text goes into the "Time" part of the cell.

For example, I'm trying to paste "11/21/2024 10:00 AM" into the Date and Time cell, but it puts all of this text under the "Date" portion, keeps the cursor in the "Date" portion, and enters the current time (i.e., 2:13 PM) in the "Time" portion of the cell, lol.

How can I accomplish this basic copy-and-paste operation with Airtable's Date-and-Time formatted column so the Date goes in the Date, and the Time goes in the Time?

For those unfamiliar, Airtable's "Date" field with "Include time" checked creates a cell with seemingly two cells within it, as shown in the screenshot below.

Finally - I have all my data in a Google Sheets spreadsheet, which I could easily copy-and-paste into the Airtable table. BUT, right now I am having to manually enter all of the Spreadsheet text because of the glitches that surface when I try to paste into Airtable.

 

Airtable Settings for the "Date" field that has "Include time" checked:

M_L_1-1732216499275.png

 

This is how the cell looks when I try to paste basic Date and Time text like "11/21/2024 10:00 AM"

M_L_0-1732216420457.png

 

TIA for your help!

 

ML

 

2 Replies 2

Try creating a formula field to convert your text into a date, and then paste that into the Date field:

Screenshot 2024-11-22 at 9.06.30 AM.png

DATETIME_PARSE(
  {Text to paste},
  'MM/DD/YYYY hh:mm A'
)
Trevor_Shannon
4 - Data Explorer
4 - Data Explorer

I just ran into this problem, and can report that I successfully copy/pasted a datetime from Google Sheets.

1. Ensure there is no space between the time and the AM/PM.  For example, 1/20/2024 10:24 AM will not paste into an Airtable datetime cell but 1/20/2024 10:24AM will paste into the cell.  You can customize the date format in Google Sheets with Format > Number > Custom date and time

2. When pasting, don't double-click into the cell to expose the date/time selector.  Just select the cell by clicking once on it and then paste.

Nov-29-2024 09-42-11.gif