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?
Date format issues
Moderators: chulett, rschirm, roy
Re: Date format issues
Please refer below link
viewtopic.php?p=388928
I guess you can use StringToDate(Trim(DSLink2.File_Date),'%dd-%mmm-%2000yy')
viewtopic.php?p=388928
I guess you can use StringToDate(Trim(DSLink2.File_Date),'%dd-%mmm-%2000yy')
Venkata Srini
Re: Date format issues
Note: Assuming that your Input date all have >2000 (20th Century)
Otherwise, please request them to provide with Century part also if you are expecting dates before 2000
Otherwise, please request them to provide with Century part also if you are expecting dates before 2000
Venkata Srini