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

How to convert string to date. And how to handle null value and this fails to work when the value is empty or void.

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

64 Views

RSS

ranoop

(@ranoop)

Posts: 13

Eminent Member

Topic starter

How to convert string to date. And how to handle null value and this fails to work when the value is empty or void.

Secondly, How to compare two date values and find the greatest of two. Do we have any built-in function to compare and find the latest date.(We tried to fix this using simple if conditions but this failed to work when the date is null or empty).

Please help.

Posted : May 1, 2016 3:00 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Q. How to convert string to date. And how to handle null value and this fails to work when the value is empty or void.

Follow-up. Can you provide an example of the text? Is it like Jan-2-15 or February 16th 2016 or?

Posted : May 2, 2016 2:06 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

To answer your date question, you can use the DURATIONDAYS function. It takes to dates and will give you the number of days between them. Using this value you can determine which date was first.

DURATIONDAYS("5/1/2016","5/2/2016") //this returns 1 since the first date is earlier

DURATIONDAYS("5/2/2016","5/1/2016") //this returns -1 since the second date is earlier

DURATIONDAYS("5/2/2016","5/2/2016") //same day returns 0

If you don't hard code in the dates you will need to check to see if you are providing both of them. If not then you need to throw an error. For example

if (date1 <> "") AND (date2 <> "") THEN

local datertn = DURATIONDAYS(date1,date2)

return datertn

else

userok("Invalid date input")

endif

Hopefully this helps. Also the durationdays entry in the centricity help file is useful too. Otherwise can you provide an example of your function?

Brad

Posted : May 2, 2016 2:39 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
4 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