04-24-2014 10:27 AM
Hi all - What I am trying to accomplish is to convert a text date (Open Date) to a DateT ime (Month End Date).
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.
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.
Need further help from the community? Please ask a new question.