I’ve already tried it with both start time and end time, and it doesn’t work. I’ve also tried with all day events and not all day events. Airtable will only accept date fields, not formula fields, which is not right. I’ve reported it to Airtable as a bug as well, but so should @Khyati_Chudasama
@Khyati_Chudasama Another Airtable consultant just gave me the workaround to this bug. Create an earlier automation action to set a normal date field to the contents of your formula field, and then use that date field in your formula.
However, be sure to still report this bug to firstname.lastname@example.org, because we shouldn’t need to go through this extra step.