Text Date conversion to datetime

[SasGuy614]

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!

[DBailey · Accepted solution]

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