Give me ur date format

use this :

DATEDIFF(#2013-09-22#, #2013-09-24#)= 2

use this..Date Functions

if u are using Sql

write a sql query using  "WITH " clause then  u can use one query result to use as the input of another query

Hi Jim,

Your approach is exactly what you want to do to get the results you are seeking. First find all patients with an office visit by using an office visit code (I believe you may be dealing with ICD-10 codes). You can actually create 3 calcs.

1. IF [Office visit code] = '01' THEN [Visit Date] END - This will return all patients with the office code of 01 and their visit date

2. IF [Office visit code] = '01' and [Surgery Code] = '10' THEN [Surgery Date] END (or you can merge the 1st and 2nd calcs with an AND function.

3. DATEDIFF('day', [Surgery Date] , [Visit Date]) - This will give the time duration between both conditions.

This is just a starting point for you to get working on the problem. Ofcourse, your fields may differ in names etc. If this doesn't work, you can mock up a few rows of your actual data with your expected results.

Thanks,

PG.

U can do this in tableau...

You can do this in Tableau directly just by creating calculated fields. If you need a starting point, you can try replicating your data in excel and I can build an initial version!

Hey Jim,

Not a full blown solution yet, but here is what I was talking about earlier. I created 2 calcs for each of the first dates (visit and surgery). Check out the calcs in the attached workbook. Is this what you are looking for?

So, in the example below, patient#17 had a first instance of CPT code greater than 99201 and less than 99205 associated with them on 10/30/2014 and the first instance of CPT code less than 90000 on 12/23/2014.

This is a version 8.3 workbook. I am not sure which version of Tableau do you have.

Oh in that case, someone may be able to help with LOD calculations for version 9 which I am not too familiar with yet. I won't be surprised if these calcs can be done in rather 1 step with LOD calcs.

Jim,

So I tried my hand at LOD calcs and I believe I got it working correctly. You can look at sheet 3 to verify the dates information by filtering a specific patient id and seeing their date of service for codes less than 90000 and the date of service for code between (99201 and 99205).

I created 5 calcs:

1.  Less than 90,000: IF ([Cpt4]) <= 90000 THEN [Dt of Svc] END

2.  Greater than 99201 and less than 99205:  IF ([Cpt4]) >=99201 and [Cpt4] <= 99205 THEN [Dt of Svc] END

3.  Visit date: {fixed [Patient #] : min([Greater than 99201 and less than 99205]) }

4.  Surgical Date: {fixed [Patient #] : min([Less Than 90000]) }

5. Datediff: DATEDIFF('day', [Visit Date], [Surgery Date])

I then took the datediff function in the filters shelf to show only 'non-null' values by selecting sum > next > special > non-null values.

Hi Jim,

I am glad this worked for you! I used to work for the State Medicaid of Nebraska but then grabbed a rather nicer opportunity at a local software development company in Ohio! Where do you work?