Hi,
I need to convert the Julian Date to date of format 'YYYYMMDD'.
I read in the forum that the DateFromJulianDay should work and give the date in format 'YYYY-MM-DD'.
My input date is 2008354 (CCYYDDD)
so this should be 2008-12-19. I used
DateFromJulianDay(StringToDecimal(Trim(INP_2.DATEP)))
but got the output as '0786-08-02' which is incorrect
The input is coming in from the file and read as char(7).
Can anyone help me why I am getting the output like this.
Thanks,
Harshada
Date from Julian Date CCYYDDD
Moderators: chulett, rschirm, roy