Date format issues
Posted: Mon Nov 13, 2017 12:13 pm
Hi,
I have a date in the file as 10/11/17 and i am trying to load it into the table.
When i use this function StringToDate(Trim(DSLink2.File_Date),'%(d,s)/%(m,s)/%yy'),
I tried to output in a seq file and its output is "1917-11-10"..Why is it giving the ouput as 1917 instead or 2017?. Is this how it should work?
I have a date in the file as 10/11/17 and i am trying to load it into the table.
When i use this function StringToDate(Trim(DSLink2.File_Date),'%(d,s)/%(m,s)/%yy'),
I tried to output in a seq file and its output is "1917-11-10"..Why is it giving the ouput as 1917 instead or 2017?. Is this how it should work?