Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

using SQL how can I filter DOCUMENT.CLINICALDATE

Trading Post

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

90 Views

RSS

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

I need to find patients who had an office visit within a date range. I have used formulas earlier. But now, I would like to know how to do it using pure SQL. Can anyone please help? Thank you.

Posted : December 20, 2012 5:38 am

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

The centricity database has a function that do that conversionts the id to a date.

dbo.Convert_ID_to_date([DOCUMENT].CLINICALDATE)

You could use a select statement like

Select * from document where dbo.Convert_ID_to_date([DOCUMENT].CLINICALDATE) between '1/1/2013' and '1/31/2013'

John Kingery

Outsde IN - @outsidein.org" rel="nofollow" target="_blank">johnk@outsidein.org

Posted : February 14, 2013 8:04 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

jmkoi, Thank you so much. This will be very useful in my future reports. I have been trying to do this for a long time.

I had to change it as follows:

dbo.Convert_ID_to_date(DOCUMENT.CLINICALDATE) between to_date ('01-01-2011', 'mm-dd-yyyy') and to_date ('12-31-2012', 'mm-dd-yyyy')

Thanks again.

Posted : February 20, 2013 2:14 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

John, forgot to ask in the previous post. Where can I find the other conversion functions?

Posted : February 20, 2013 2:46 am

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

baj said:

John, forgot to ask in the previous post. Where can I find the other conversion functions?

Bar,

You can find them as functions in the centricity database. We use the MS-SQL version of CPS. It looks like you are using the Oracle version and I believe you will find those functions in the same area.

Posted : February 21, 2013 3:24 am

baj

(@baj)

Posts: 99

Estimable Member

Topic starter

Found it under Stored Procedures. Thanks a lot.

I am using the Oracle version. That's why I had to change the date format in the SQL you sent, I believe.

Posted : February 21, 2013 3:39 am

Share:

24 Forums
9,942 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0