Check whether creation date is in a certain period

Hi!

I have a list of different entries (rows) per user that contains a creation date.
Example: Miran xxxx 11/30/2020

On a different tab I have a list that contains a period per user.
Example
Miran 10/30/2020 - 12/31/2020
Miran 02/01/2021 - 04/01/2020

I need to check whether the creation date of a row of a user is in a certain period.
If so then I need to perform an action. Any ideas on how to implement this?

That period should be separated into a start time and end time.

I imagine you can use an if then else like this, let’s call it “Check”.

If Entry creation date is before Starting date then False.

Else if Entry creation date is after Ending date then False.

Else True.

2 Likes