/* Created by Acmeware, Inc., All Rights Reserved					*/
/*--------------------------------------------------------------------------------------*/
/* This function returns a computed datetime based on a date and time string typical	*/
/* of MEDITECH Customer Defined Query (CDS) responses 					*/
/*											*/
/* Parameters: 										*/
/*	@DatePart: 6 character date (e.g., "030107")					*/
/*	@TimePart: 4 character time (e.g., "1723")					*/
/*											*/
/*	Return Value: (datetime)							*/
/*											*/
/* Note: 										*/
/*--------------------------------------------------------------------------------------*/
/*											*/
/* THIS SOFTWARE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, 	*/
/* INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF MERCHANTIBILITY AND 	*/
/* FITNESS FOR A PARTICULAR PURPOSE.							*/



CREATE        FUNCTION dbo.fxConvertCharDate (@DatePart varchar(20), @TimePart varchar(20))  



RETURNS datetime AS  
BEGIN 
	SET @TimePart = RIGHT('000000' + @TimePart, 6)
	RETURN Convert(Datetime, @DatePart + 
		' ' + LEFT(@TimePart , 2) + 
		':' + SUBSTRING(@TimePart, 3, 2)  + 
		':' + RIGHT(@TimePart, 2))  
END