Forum Discussion

LuciferMstar's avatar
LuciferMstar
Helper I
3 years ago

Difference between dates in columns with multiple values

Hello there, helpful people,   I might need your brain power regarding a few calculations that at first I thought it made sense theoretically, but in practice I can't wrap my head around it.    B...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi LuciferMstar ,

 

I am confused about your calculation logic. I can see two dates in Status 2 for ID 153. Should both dates in Status 2 larger than both dates in Status 1 for each ID or just need one meet your logic? 

Please show me the result you want and share a sample file with me. This will make me easier to find the solution.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

LuciferMstar's avatar
LuciferMstar
Helper I
3 years ago

Hi Anonymous ,

 

Let's take a simple approach, on the same table.

Because the data looks like that I still didn't figure it out how to compare if each value on Status 2 is greater than each value on Status 1, and if it is, then perform a DATEDIFF where the condition is true. Whatever I tried it looks on the same row, but because I have blank it returns blank.