Help

Setting fixed time date based on another date

Topic Labels: Dates & Timezones
507 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Casper_Hoegalme
4 - Data Explorer
4 - Data Explorer

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 :slightly_smiling_face:

0 Replies 0