The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
Hi Team,
Soooo, because Airtable doesn’t have a stand alone time field (it really needs one)
I need to create a ridiculous bodge…
I start with a Date field set to local format lets call it {CommDate}
Next I have a bulk standard number field set to in...
I should add that I’ve had success with using;
DATETIME_PARSE((CONCATENATE({Start Date}, {Time})), ‘YYYY-MM-DDT00:00:00.000ZHH:mm’, ‘en-au’)
To do the CONCATENATE and DATETIME_PARSE steps in one field instead of two
I separated them out though to see...