
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 19, 2022 07:09 AM
I have a table where I need to mark when flights take off between 22:00 - 07:00. I would like an If statement where it marks the record with an X when this is true. I have date fields for the departure time but I just cant quite find how to have a general standing marker based on times rather that a specific time AND date.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 19, 2022 07:32 AM
Hey kevin! Its kevin, I figured it out for you. Converted the times to decimals.
IF(OR({Departure Time (Airport Time)} < 7.0,
{Departure Time (Airport Time)} > 22.0), ‘x’, BLANK())

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 19, 2022 07:32 AM
Hey kevin! Its kevin, I figured it out for you. Converted the times to decimals.
IF(OR({Departure Time (Airport Time)} < 7.0,
{Departure Time (Airport Time)} > 22.0), ‘x’, BLANK())

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 19, 2022 09:11 AM
You could also use the HOUR() function to pull the hour out of a time field.
