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

remove time from date/time string

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

2 Users

0 Reactions

90 Views

RSS

cecild

(@cecild)

Posts: 314

Reputable Member

Topic starter

I have pulled the date from the immunizations table, it comes with the time as well. What is the code to remove the time from this string. Example: '2013-06-05 12:00:00 AM'

thanks

Posted : June 25, 2015 9:24 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

I have been using the following without any issues

sub(datetime,1,match(datetime," ") -1)

Posted : June 25, 2015 9:55 am

cecild

(@cecild)

Posts: 314

Reputable Member

Topic starter

Thanks Gibson

Posted : June 25, 2015 10:13 am

cecild

(@cecild)

Posts: 314

Reputable Member

Topic starter

The below code is what I'm using to extract vaccine date. Works fine except I would like to get just the date and not the time. I show the returned values at the bottom. When I add sub(rtnvalue1,1,10) I get nothing.

/* Function finds the last date rcvd Influenza vax */


{!fn fnGetInfluVax() {
local CvtDate = ""

local rtnvalue1

local VaxList1 = ""

local VaxAray1 =""

local cmax1

local VaxName1 = "Influenza"
VaxList1 = IMMUN_GETLIST()

VaxAray1 = getfield(VaxList1,"|","")

cmax1 = size(VaxAray1)

local g

local aRow1

rtnvalue1 = ""
for g=1, g<=cmax1, g=g+1 do

	aRow1 = getfield(VaxAray1[g],"^","")

	if (str(aRow1[3])= VaxName1) then rtnvalue1 = val(str(aRow1[30]))
	else ""
	endif
endfor
if (rtnvalue1 = "") then rtnvalue1 = "None"
else ""
endif
DOCUMENT.FLUVAXDAT = rtnvalue1  /*Returns "2013-10-25 12:23:00 PM"  */

return rtnvalue1	/*Returns 10/25/2013 12:23:00 PM */
}

}


                    
                    	
                            Posted : June 25, 2015 10:53 am



        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 gibsonmi
                        (@gibsonmi)
                        
                                                    
                        
                            Posts: 827                        
                        
                            Prominent Member                        
                            
		            
	                    
                    
                

                
                	
                                                 
                    	
							                        
                                            
                    
                        sub() requires a string, sub(str(rtnvalue1),1,10) should work in this case.
I don't remember which one it was but I had an issue with one of the new functions returning dates such as 2015-1-1, which has less than 10 characters.  That's why I had starting using match() on a blank space instead of the 10 digit approach.
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : June 26, 2015 2:50 am		                    
						
                    	
                    
                

                
              

          


        
        
    
				
                            
                
                	                		
                                        
                        			
			                
					
		 cecild
                        (@cecild)
                        
                                                    
                        
                            Posts: 314                        
                        
                            Reputable Member                        
                            
		                  
	                    
                    
                

                
                	
                         Topic starter
	                         
                    	
							                        
                                            
                    
                        I thought I had tried that in my several attempts but must have mis-typed.  I worked and thanks again for your help.
Cecil
                                                                                                	                                                
                                                         
                                                    
	                                        
                    
                    	
                            Posted : June 26, 2015 5:01 am


        
            
				            
				                    
                         Forum Jump:
                        
                        
                    
								
														                        
                              Previous Topic
                            Next Topic


		
		





    
         Share:
        
        
						            
				                    
                        
                    
				            
			            
				                    
                        
                    
				            
						        
        
    
	

			        
            
                
                Forum Information
            
            
                
				                    
                        Recent Posts
				                    
                        Unread Posts
				                     Tags
            
        
        
			
			                
                    
                        
                            
                            24
                            Forums
                        
                        
                            
                            9,942
                            Topics
                        
                        
                            
                            39.9 K
                            Posts
                        
                        
                            
                            0
                            Online
                        
                        
                            
                            6,470
                            Members
                        
                    
                
			
            
                
                    
					Our newest member: Erin Kistner                
				                    
                        
						Latest Post: Artificial Intelligence in Healthcare Virtual Summit- Nov. 8-9, 2024
                    
				            

            
                
                    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 version 2.4.0



	
				
                    

                        © Community Healthcare Users Group  2024  |  Contact Us

                        Twitter
Facebook
Instagram
Youtube
LinkedIn



Scroll to top