IntervalMatch or If condition

[fabdulazeez]

Hi All,

I have multiple dates for which I need to find the shift (Current Shift, Previous shift or Next Shift). Each shift could be of 12 hours. What could be the best approach.

Should I create a table defining the shift and use IntervalMatch 

Or

Should I use an if condition directly in my script?

[Mark_Little]

Hi @fabdulazeez 

Really depends on the use case and how the end user will interact with the data. 

Interval Match is designed for this can of thing, but can be a little more effort to set up if you only want a shift attach to a time. 

[fabdulazeez]

I had tried both approaches, but couldn't identify the reason to select one of those. My use case is to have a single table with a field representing the shift. 

So if I am using Interval Match I would have to join and do a resident load. So I was thinking using an If condition could benefit.

At least from performance point of view could you suggest which is a better approach. I will always have only 3 shift.