I have a Google Sheet with 3 separate columns for Day Year and month … and I would like to instead enter a Date field …It’s a simple table I’m moving to Airtable because it’s more user friendly IMO. … iut’s for about 2000 records.
See the picture att...
In my base I have a field for Date … When I used your formula , the times are correct but It populates Today’s date … I’m assuming that’s because of the “NOW” wording in your formula … I changed the now to “Date” to call in the date that’s already in...
I’m almost there … I first use concanate formula to string the text together and then I used Date time parse
the following formulat
DATETIME_PARSE({Text}, ‘M/D/YYYY’)
It worked except that it displays the time as 12:00am … is there an edit I can do t...
