Setting fixed time date based on another date

Hey everybody.

I recently got introduced to Airtable and I am currently setting it up for project management.

For estimating when a task is completed I want to know whether a date time is after the end of the workday. E.g. Raven starts a 2-hour task at 16:30 with the workday ending at 17:00 - that should be picked up by the system.

My intended approach is to add the raw time to the kick-off datetime and then compare this to the same datetime except at 17:00. This is where I have an issue: How do I extract the date, month and year from a datetime and then set my own HH:mm parameter?

Virtual cookie to the wizard who can get me out of this nut :grin:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.