Change the string to specific date format in User variable

[bgudapati]

We need to change the string to specific date format in User Variable Activity.

One option would using OCONV function
Input string coming in as 20120731
Expected Output : 31-AUG-2012

Can you please let me know what format do I need use in the function
Oconv(Inputvalue, format)

What are other options available to convert string to date in User variable activity

Thanks

[ArndW]

There are actually 2 step involved, first you need to parse the string value into the internal date format, then output that internal date as a string

Code: Select all

OCONV(INCONV(UserVariable[1,4]:'-':UserVariable[5,2]:'-':UserVariable[7,2],'D4-YMD'),'D4-DMY[2,A3,4]')

I'm not at a PC where I can check the syntax, but it should be close enough and the descript can be found at http://publib.boulder.ibm.com/infocente ... ction.html

[ray.wurlod]

Are you looking for the end of the next month or the corresponding day (date) in the next month?

I don't believe Arnd's parsing is necessary; Iconv("20120731","D4YMD") should work correctly. After that, something like the MONTH.LAST Transform might be what you are looking for.

[zulfi123786]

OConv in parallel jobs ?

[BI-RMA]

OConv in parallel jobs ?

No. In a UserVariables-Activity (Sequence).