Determining Whether a Date Field Is Within a Specified Period- FineBI Document

Last update： 2023-09-28

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:

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

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.