https://community.qlik.com/t5/App-Development/Qlikview-Developer/m-p/1687978#M52469 <P>A customer has a set of date values in different formats. Some dates are in Julian date format; some dates are text strings. How can a developer ensure the data is loaded in a consistent format? <SPAN class="tagnamecolor"><SPAN class="tagcolor">&lt;</SPAN>a<SPAN class="attributecolor"><SPAN>&nbsp;</SPAN>href<SPAN class="attributevaluecolor">="<A href="https://www.google.com/url?q=https://www.credosystemz.com/training-in-chennai/best-amazon-web-services-training-in-chennai/&amp;sa=D&amp;source=hangouts&amp;ust=1585293849530000&amp;usg=AFQjCNFkMmevlGpZMbdMkjIIeEBe9iR8UA" target="_blank" rel="nofollow noreferrer noopener">https://www.credosystemz.com/training-in-chennai/best-amazon-web-services-training-in-chennai/</A>"</SPAN></SPAN><SPAN class="tagcolor">&gt;</SPAN></SPAN><SPAN>awstraininginvelachery</SPAN><SPAN class="tagnamecolor"><SPAN class="tagcolor">&lt;</SPAN>/a<SPAN class="tagcolor">&gt;</SPAN></SPAN></P> Sat, 16 Nov 2024 18:53:04 GMT CredoSystemz 2024-11-16T18:53:04Z https://community.qlik.com/t5/App-Development/Qlikview-Developer/m-p/1687978#M52469 <P>A customer has a set of date values in different formats. Some dates are in Julian date format; some dates are text strings. How can a developer ensure the data is loaded in a consistent format? <SPAN class="tagnamecolor"><SPAN class="tagcolor">&lt;</SPAN>a<SPAN class="attributecolor"><SPAN>&nbsp;</SPAN>href<SPAN class="attributevaluecolor">="<A href="https://www.google.com/url?q=https://www.credosystemz.com/training-in-chennai/best-amazon-web-services-training-in-chennai/&amp;sa=D&amp;source=hangouts&amp;ust=1585293849530000&amp;usg=AFQjCNFkMmevlGpZMbdMkjIIeEBe9iR8UA" target="_blank" rel="nofollow noreferrer noopener">https://www.credosystemz.com/training-in-chennai/best-amazon-web-services-training-in-chennai/</A>"</SPAN></SPAN><SPAN class="tagcolor">&gt;</SPAN></SPAN><SPAN>awstraininginvelachery</SPAN><SPAN class="tagnamecolor"><SPAN class="tagcolor">&lt;</SPAN>/a<SPAN class="tagcolor">&gt;</SPAN></SPAN></P> Sat, 16 Nov 2024 18:53:04 GMT https://community.qlik.com/t5/App-Development/Qlikview-Developer/m-p/1687978#M52469 CredoSystemz 2024-11-16T18:53:04Z https://community.qlik.com/t5/App-Development/Qlikview-Developer/m-p/1687984#M52472 <P>the julian date can be processed by: .</P><LI-CODE lang="python">Date(MakeDate(1900 +(left(text(Julian_Date),1)* 100) + mid(text(Julian_Date),2,2) ) + (right(text(Julian_Date),3) - 1 ) )</LI-CODE><P>&nbsp;</P><P>more information in this link : <A href="https://community.qlik.com/t5/QlikView-Documents/Julian-calendar/ta-p/1664195" target="_self"><SPAN class="lia-link-navigation child-thread lia-link-disabled">Julian calendar</SPAN></A></P> Thu, 26 Mar 2020 08:52:09 GMT https://community.qlik.com/t5/App-Development/Qlikview-Developer/m-p/1687984#M52472 Taoufiq_Zarra 2020-03-26T08:52:09Z