Hello,
I am new to airtable and i have a challenging task.
I am using airtable as a CRM for my business.
We want to create a view for records (Leads) with created time between 08:00 PM and 09:00 AM
The reason for doing that is because i want to use this view as a trigger for zapier.
I could not find any available filter that handle time of the day.
I have already created a column that show only time of the day by using the below formula:
DATETIME_FORMAT({Date Of Creation},
“LTS”)
Please check the image
how this data can be used to filter certain time?
Thanks in advance for any support or advice on this.
Regards,