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...
