Selecting Rows between two variables and dates

[sriniprad08]

Hi Team,

Hope you are well.

I need help. I have to select the data based on the below conditions

First step 

1) [start date] between "2022-01-20" and "2022-02-20" AND  [END DATE] "2022-01-20" and "2022-02-20" 

Second step

2) Create a flag based on the conditions if the [date1] < [date2]

Please let me know how to go about this,

Thanks and Regards,

Srinivas

[Dev73 · Accepted solution]

Hi @sriniprad08 , 

 please look at the solution and please confirm are you looking this type of solution or something else.

[Aryasuta_Panda · Accepted solution]

Hi, This solution might help you.

Thanks

[sriniprad08]

Hi @Dev73 ,

Thank you very much. Appreciate the time.

Regards,

Srinivas