DSXchange

Hi All,

I have a requirement to convert input string to date fomat yyyymmdd.
Input string is coming as 'yymmdd' format. Ie if input data is 190110, output should be 20190110.

I used the following conversion:
The out put I am getting as 19190110..The year is 1919 instead of 2019. How to rectify this?

For one way, check here and then search for year_cutoff. Allows you to define what is also known as the "Century Pivot".

Thanks Craig,

To use date tag, do I need to use basic transformer?

Nope, not at all.

ok, then may be my expression is wrong hence getting parsing error.

If I want to extract cutoff year from the input field, I am using expression as below:

StringToDate(InputLink.Datestring,"%NNNNyy")

I am getting parsing error for this.

I assume you need to replace NNNN with the actual year to use as the cutoff / pivot year.

Thanks Craig. I set up cut off year as 2000 and received the desired output.