Date conversion
Posted: Mon Jan 21, 2019 11:48 am
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?
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:
Code: Select all
DateToString( StringToDate(Lnk_TDCO.TRAIL_DATE,"%yy%mm%dd"),"%yyyy%mm%dd")