Determining Whether a Date Field Is Within a Specified Period

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.

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:

Fields in the formula need to be selected from the left area and cannot be entered manually.

Formula explanation:

Demonstration

For the demonstration of the added formula column, see section "Preview".