Converting String to Month

[dodda]

Hello

I have a requirement where i am getting a string like 01-JAN-2009 from file. I have to use some logic in such a way that i need to extract JAN and convert that to 01. if get 01-FEB-2009 then i need to get 02 and so on. Is there a function to get that value.

Thanks

[ray.wurlod]

Code: Select all

(Index("JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC", InLink.TheString[4,3], 1) - 1) / 3 + 1

for the month number. Store that in stage variable svMonthNumber.

Code: Select all

Right("00" : svMonthNumber, 2)

will yield that number with a leading zero if necessary.