I have a string "201009" which is YYYYMM format.
I need to convert it to two different formats:
Sept, 2010 and September, 2010 to be used in report titles.
Can someone show me how in the Transformer stage ?
thanks!
convert string YYYYMM to date format
Moderators: chulett, rschirm, roy
3 stage variables:
Then construct your output string using your required format(s) and the 3 stage variables, i.e. "svMonthValueShort:', ':svYearValue"
Code: Select all
svYearValue In.DateString[1,4]
svMonthValueShort FIELD('Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec',',',In.DateString[5,2])
svMonthValueLong FIELD('January,February,March,April,May,June,July,August,September,October,November,December',',',In.DateString[5,2])
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>