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

converting mmddyyyy to yyyymmdd to use mel sort function

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

66 Views

RSS

dmoroz

(@dmoroz)

Posts: 24

Eminent Member

Topic starter

Hello all,

Does anyone have a function or mel code snippet that converts a date into yymmdd format?

Thanks

Posted : December 13, 2016 3:55 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

The function below could help you out...I set it up so that it can be expanded over time if you wanted different formats. Disclaimer: Untested, could crash or cause issue.

fn convertDate(d, f) { /* Incoming Parameters: d: A date, formatted as 01/01/2000 f: How you want your output string to be formatted

Example: convertDate(._TODAYSDATE, "yyyymmdd")
Returns: 20161213
*/

local retStr = ""
local dateArray

cond
case d == "": /*Do Nothing*/
case match(d, 1, "/") <= 0: /*Do Nothing*/
else:
dateArray = getfield(d, "/", "")
if size(dateArray) == 3 then
cond
case f == "yyyymmdd": retStr = dateArray[3] + dateArray[1] + dateArray[2]
endcond
endif
endcond

return retStr
}

Posted : December 13, 2016 4:14 am

dmoroz

(@dmoroz)

Posts: 24

Eminent Member

Topic starter

That works perfectly!

Thank you very much!

Posted : December 13, 2016 7:47 am

dmoroz

(@dmoroz)

Posts: 24

Eminent Member

Topic starter

May I ask if you had a way of converting it back into dd/mm/yyyy format?

I was looking at modifying your logic to do it, however I am stuck at the match, when converting from dd/mm/yyyy to yyyymmdd you used the "/" as the deliminator, what would you use for converting it back?

I played around withmaking it a string and adding a deliminator character, however then the mel sort function wont work with it.

Thanks again

Posted : December 13, 2016 9:20 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

RE: Changing it back...

We could use a different function to do that, one that assumes an 8 character string always formatted as YYYYMMDD. In that case, we could do something like below (disclaimer: untested).

fn convertStringToDate(d, f) { /* Incoming Parameters: d: A date, formatted as YYYYMMDD f: How you want your output string to be formatted

Example: convertDate(20161213, "mm/dd/yyyy")
Returns: 12/13/2016
*/

local retStr = ""

cond
case d == "": /*Do Nothing*/
case size(d) == 8:
cond
case f == "mm/dd/yyyy": retStr = sub(d, 5, 2) + "/" + sub(d, 7, 2) + "/" + sub(d, 1, 4)
endcond
endcond

return retStr
}

Posted : December 13, 2016 10:12 am

Share:

24 Forums
9,940 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