Datetime within Datetime range?

[Grantham]

Good day All

Im relatively new to Alteryx and and would like to ask for help with a problem: 

I have a 2 files, 1st - indicated the system generated date and times ( start and end ) of customer visits and a 2nd - indicating the actual datetime that visit.

I need to know if the actual date time falls within the system generated datetime = Yes or outside = No or ether the start or end date falls within the range =  Start/End Yes.

Alternatively : if only the Start Actual datetime falls within or outside the generated datetime range?

File 1 :  Generated datetime

Customer acc	System Start date time	System Start date time
123	2022/06/28 10:00	2022/06/28 10:30
456	2022/06/28 13:30	2022/06/28 14:00
789	2022/06/28 16:00	2022/06/28 16:30

File 2 : Actual datetime

Caller ID	Actual call Start	Actual call End
Joe Smith	2022/06/28 10:10	2022/06/28 10:20
Joe Smith	2022/06/28 13:10	2022/06/28 13:25
Joe Smith	2022/06/28 16:25	2022/06/28 16:35

Thank you

[flying008]

Hi, @Grantham 

Could you give a table as your want output form ?

[AmrMansour]

 Hi @Grantham 

Happy to have you in our user community. 

I can see that there are no matching records between the 2 data sets ( unique ID). Does that mean that you need to " Append Fields " of all (Actual datetime) records to ( Generated datetime and then create your condition using a Custom "Filter "? 

Or you need a table of correspondence ( between Customer acc and Caller ID ) and then limit the matching by using "Join " and then create your condition using a Custom "Filter "? 

Cheers,

Amr Mansour

Digital CSM

[IraWatt · Accepted solution]

Hey @Grantham,

Here is an example of how to do this:

The first step is to convert you text data to a datetime so that you can compare them. I did this using the formula DateTimeParse. I then used an IF statement to compare the columns. 

Any questions or issues please ask :)
HTH!
Ira

[Grantham]

Thank you for the help 

[IraWatt]

No worries @Grantham 😄