Overview
Preview
You may need to determine whether a time field is within a specified period. For example, you may need to determine whether the Invoicing Time is between the Recording Time and the Delivery Time, as shown in the following figure.
Implementation Method
You can use the IF function to meet this requirement.
Procedures
Sample data: Time Judgement Table.xlsx
Creating an Analysis Subject
Create an analysis subject and upload the sample data with all fields selected by default.
Determining Whether a Date Field Is Within a Specified Period
Add a Formula Column named Judgement Result, enter the formula: IF(AND(Invoicing Time>Recording Time,Invoicing Time<Delivery Time),"Yes","No"), and click OK.
Note:Formula explanation:
| Formula | Explanation |
|---|---|
AND(Invoicing Time>Recording Time,Invoicing Time<Delivery Time) | Determines whether the Invoicing Time is between the Recording Time and the Delivery Time. |
IF(AND(Invoicing Time>Recording Time,Invoicing Time<Delivery Time),"Yes","No") | Returns Yes if the condition is true, otherwise, returns No. |
Demonstration
For the demonstration of the added formula column, see section "Preview".
