Timestamp field between two other fields

[Anonymous]

See attached.  I'm thinking this is a formatting issue but I've lost enough time to figuring it out myself.

I'm trying to write the set analysis for Task_Opened_At is between Visit_FirstViewByDay and Visit_IncidentWindowEnd but nothing has worked for me.  The results should be zero so I'm testing with Task_Opened_At <= Visit_FirstViewByDay and >= Visit_IncidentWindowEnd.  This should count all the records but I'm getting no results.

[Anonymous]

This is working!  I was thinking I could somehow include this calculation in my load script but I wasn't sure how to get there and this did it for me.  Thanks!

In my actual data set I am pulling in 90k+ tasks and not all of them match Visit details.  Would changing the join to left join keep only the tasks that match or when I add count_flag in the last load should I filter out tasks that dont have a visit_date?

[#3]

Yes, changing to left join will keep only the tasks that has matching visit details, if that fulfills your business requirement.