Date Conversion
Moderators: chulett, rschirm, roy
Thanks for all of your inputs and suggestions.
finally I stick with this derivation
Iconv(DSLink71.HIRED, "DMDY").
I have another question , in .csv file the values of the column is '11/3/2007' in this format.but when reading from sequential file it is reading only last 2 digits of the year.I want to read all 4 digits.Can you plesae let me know where to make changes in seq file to get full year
Thanks
finally I stick with this derivation
Iconv(DSLink71.HIRED, "DMDY").
I have another question , in .csv file the values of the column is '11/3/2007' in this format.but when reading from sequential file it is reading only last 2 digits of the year.I want to read all 4 digits.Can you plesae let me know where to make changes in seq file to get full year
Thanks
HI thanks for all of your inputs and suggestions
I stick with this derivation
Iconv(DSLink71.HIRED, "DMDY[2,2,4]")
I have another question,in .csv file the format of the column looks like this
'11/03/2007', but when I am reading from seq file, it is showing only 2 digits o fthe year.Can you please tell me what needs to be done on seq file side to get all 4 digits
Thanks
I stick with this derivation
Iconv(DSLink71.HIRED, "DMDY[2,2,4]")
I have another question,in .csv file the format of the column looks like this
'11/03/2007', but when I am reading from seq file, it is showing only 2 digits o fthe year.Can you please tell me what needs to be done on seq file side to get all 4 digits
Thanks