How to check the date in between two dates

[SH_94]

Dear Community,

I have question on the dates below and would like to ask how can we check whether specific date are actually in between both dates as per screenshot below:

I have also attached the working below for your reference.

[JarekSkudrzyk]

@SH_94 

Hi, you need to use DateTimeDiff functions - regular subtraction/addition does not work in alteryx in the way it does in Excel.

[SH_94]

Hi @JarekSkudrzyk ,

Can you show me in alteryx how to do it? 

A alteryx workflow would be helpful.

Thanks again for the help.

[JarekSkudrzyk · Accepted solution]

@SH_94 

sure thing: