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")