Text Date conversion to datetime

SasGuy614 — Thu, 24 Apr 2014 14:27:42 GMT

Hi all - What I am trying to accomplish is to convert a text date (Open Date) to a DateT ime (Month End Date).

For example:

OpenDate = 2008-12-12

Below is the code I am using to create a OpenMonth Field

	format MonthOpened DateTime22.3;
	MonthOpened = dhms(input(OpenDate,yymmdd10.),0,0,0);

OpenMonth = 12DEC2008:00:00:00.000

I keep getting a conversion of the text date to date time instead of 31DEC2008:00:00:00.000

I know that I need to nest the intnx function but I can't seem where to correctly next the function.

intnx('month',MonthOpened,0,'end')

I know that I can do this in multiple steps, but I would like to create one nested function to do the conversion for me.

Thanks!

Re: Text Date conversion to datetime

DBailey — Thu, 24 Apr 2014 14:36:20 GMT

MonthOpened = dhms(intnx('month',input(OpenDate,yymmdd10.),0,'end'),0,0,0);