https://community.qlik.com/t5/Talend-Studio/Converting-Java-dates-to-Julian-Dates/m-p/2325258#M94874 how do you convert Java dates to julian dates using talend? Sat, 16 Nov 2024 13:45:40 GMT _AnonymousUser 2024-11-16T13:45:40Z https://community.qlik.com/t5/Talend-Studio/Converting-Java-dates-to-Julian-Dates/m-p/2325258#M94874 how do you convert Java dates to julian dates using talend? Sat, 16 Nov 2024 13:45:40 GMT https://community.qlik.com/t5/Talend-Studio/Converting-Java-dates-to-Julian-Dates/m-p/2325258#M94874 _AnonymousUser 2024-11-16T13:45:40Z https://community.qlik.com/t5/Talend-Studio/Converting-Java-dates-to-Julian-Dates/m-p/2325259#M94875 Hi Jamie, <BR /> <BR />After speaking directly, we found that Jamie was trying to convert longs (number of milliseconds since the epoch) to regular date fields. <BR /> <BR />In order to do this, we need to read the data in as a long, and then convert it to a date type. I used a tMap from the long to date (dont forget to set the date format in the schema to "MM/dd/yyyy"), and the transform expression for the date field is: <BR /> <BR />new Date(row1.LongDate) <BR /> <BR />output looks like: <BR /> <BR />1240001474750|04/17/2009 <BR />1240770188953|04/26/2009 <BR />1241957891640|05/10/2009 <BR />1242236149265|05/13/2009 <BR />1242070538187|05/11/2009 <BR />1242300633500|05/14/2009 <BR />1245587646531|06/21/2009 <BR />1245684007687|06/22/2009 <BR />1190027854328|09/17/2007 <BR /> <BR />HTH, <BR /> <BR />Thomas Tue, 22 Sep 2009 17:04:38 GMT https://community.qlik.com/t5/Talend-Studio/Converting-Java-dates-to-Julian-Dates/m-p/2325259#M94875 _AnonymousUser 2009-09-22T17:04:38Z