formula

[Hi2023]

hi,

new here! 

how would I write this formula in Alteryx?

•Out of the cases with Email (which should be within a day of initial out date), on what day did the case get resolved?

•Out of the cases without Email, on what day did the case get resolved?

any suggestions would be helpful!

thanks

[npariso]

Hi Veronica, can you provide an example of the data set that you are using? It would be helpful to show an example of the input you currently have and the output you desire.

[Hi2023]

I think it should be a datetimediff ?   Rest indicator I means w email text and R means without email text

[binuacs · Accepted solution]

@Hi2023 are you looking for something below

[Emmanuel_G]

@Hi2023 

It's possible for this input file to provide excepted output ?

[esmalley]

datetimediff is definitely the answer, although I fear they may need a business-days-only answer, in which case they'll need a business days macro.