‘DD/MM/YYYY H:mm’)
The Datetime_parse format was the issue. Originally I had it as M/D/YYYY. I have changed it to DD/MM/YYYY, however, the result is MM/DD/YYYY. So i use airtable date formatting to change it back to DD/MM/YYYY. I am still confused wi...
IF({Class Time Booked}=“9:00 - 9:30”,“9:00”,IF({Class Time Booked}=“9:30 - 10:00”,“9:30”,IF({Class Time Booked}=“10:00 - 10:30”,“10:00”,IF({Class Time Booked}=“10:30 - 11:00”,“10:30”,IF({Class Time Booked}=“11:00 - 11:30”,“11:00”,IF({Class Time Booke...
This is the formular i am trying to use.
DATETIME_PARSE(
DATETIME_FORMAT(
{Date start},
‘M/D/YYYY’
)&’ '&if(formula),
‘M/D/YYYY h:mm a’
)
I dont have my notebook with me can access from my mobile
The {Date Start} field is input does not include time....
I have been trying to add a date and a time together. As suggested my Date is a date field and my time is a formular feild. The problem i am having is some of the field provide a correct result and some give out #error!! What should be the cause of t...
