Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Converting Juilan Date To Datetime

Hi All,
I want to convert the julian date of format YYYDDD into YYYYMMDD.
My source file is EBCDIC so that column containing julian date is cuming as Packed value with data type BigDecimal.
So Please guide me how to convert this date to format YYYYMMDD
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi
You might create a custom routine in TOS.
 public static java.util.Date juLianToDate(int date) {  
int year = (date / 1000) + 1900;
int dayOfYear = date % 1000;
Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.YEAR, year);
calendar.set(Calendar.DAY_OF_YEAR, dayOfYear);
return calendar.getTime();
}

Hope this help you.
Regards,
Pedro