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

Function Help - Formatted Date

General Discussion

Last Post by cecild 8 years ago

7 Posts

6 Users

0 Reactions

62 Views

RSS

kellyblake

(@kellyblake)

Posts: 34

Trusted Member

Topic starter

Does anyone have a function that takes a date format that drops the leading zeros and formats it in a 10-digit date format?

We are going to start using the Immunization HTML form, and I need to create visibilities based on the patients last vaccine date. But the delimited list from IMMUN_GETLIST() drops the leading zeros. Why would they do that??

1753027034385120^1753027034385120^Influenza^Flulaval Intramuscular Injectable^Flulaval Intramuscular Injectable^1^Y^^N^^V01^125152^^17100020202200^^54569641800^141^0.5^mL^IM^C28161^Left Deltoid^LD^GlaxoSmithKline^OTH^123654^6/7/2016^8/19/2014^kblake^7/20/2015 3:57 PM^D^^^^^^Y^kblake^7/20/2015 3:57 PM^^^^0^

Thanks!

Posted : October 21, 2015 9:50 am

dcarpenter

(@dcarpenter)

Posts: 323

Reputable Member

I do not have a function, but all of the date fields in MEL code (ADDDATES,DURATIONDAYS,SUBTRACTDATES) work without the leading zeros. I just tested it with the dates you posted in your code and it calculated just fine, so you should be able to use it for visibility fields no problem.

Posted : October 22, 2015 7:50 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

Building on dcarpenter's response, if you plug it in to Adddates and add 0 it will return the ten digit date, for example -
adddates("7/3/2015","0","0","0")
returns
"07/03/2015"

Its the same way I test for a valid date, and invalid date will return blank, a valid date returns the same date.

Posted : October 22, 2015 9:10 am

aaltotsky

(@aaltotsky)

Posts: 129

Estimable Member

Actually, I think the date format is based on your Region and Language settings (see control panel). I have not validated this theory, but take a look at default settings for short date.

Posted : October 23, 2015 6:20 am

cecild

(@cecild)

Posts: 314

Reputable Member

I pull field 30 with and run it through this sub(str(rtnvalue1),1,10) it gets rid of the time and just use the date and makes it a string. rtnvalue1 is the field 30 from the array.

Then to do your comparisons just something like this DurationDays(str(date from imms),str("09/01/2015")) > 365

If I understand your question this should work.

Cecil

Posted : October 26, 2015 7:53 am

cdpaxson

(@cdpaxson)

Posts: 27

Eminent Member

Hello Cecil,
What do you mean by running field 30 through this sub(str(rtnvalue1),1,10)? What would this look like?
Thanks,
Carolyn
[email protected]

Posted : June 29, 2016 6:31 am

cecild

(@cecild)

Posts: 314

Reputable Member

This will take a date field with time and strip the time off. It takes the first 10 characters of the field.

Cecil

Posted : June 29, 2016 7:45 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