Playing With Date in Pentaho Spoon
I got the date in which there was a date field in form dd/mm/yy and I needed to convert into the format of dd/mm/yyyy.
Oops!!! How to specify the year 2000 in the date, coz in the date format meta data i can change format to dd/mm/yyyy but can’t specify the year number.
Then, something hit into my mind and I specified the format as dd/mm/20yy and Bingo!!!
The sample transformation can be downloaded here.