1st Date of Service after Emergency Room visit, then calculate day difference formula

[MaryCann]

Hi you wonderful Alteryx folks!  I just love how my questions actually get answered with Alteryx.  It's great.  

Okay, this next question.  So, I need to find out the first service date after an Emergency department date.  Then DATEDIFF something for subtracting first service date from Emergency room date.  So, here's a snip of how far I've gotten:

That first file on the left is the services file.  Don't know if you need that or not.  

A Pre-Thank you to the Alteryx community for your help.  :)

[mceleavey]

Hi @MaryCann ,

We can't see your data. Can you provide a bit of mock data showing where you got to and what you want to do?

M.

[Robin_McIntosh]

You can do something like this to get the first DOS after ER.

[MaryCann]

I'm attaching an example file of what the file looks like.  Notice the 1 hospital visit date, with multiple service dates.  I want the first service date after the hospital visit date.  And, of course, for some - there is no after hospital visit service date.

[Robin_McIntosh · Accepted solution]

@MaryCann - Based on your sample input, is this what you're looking for?

[MaryCann]

@Robin_McIntosh  - that looks like what I'm looking for!  Let me plug it in and see what happens!

I'll update if it works.  :)

[MaryCann]

Just letting ya'all know - I'm part of a new Electronic Health Record training for the next 3-weeks.  So, won't get a chance to test whether or not it works until after that.