https://communities.sas.com/t5/SAS-Enterprise-Guide/ModifiedDate-value-in-project-xml-of-egp-file/m-p/319366#M21417 <P>Thanks for such a quick response.. much appreciated!</P> Thu, 15 Dec 2016 19:05:11 GMT dougcrites 2016-12-15T19:05:11Z https://communities.sas.com/t5/SAS-Enterprise-Guide/ModifiedDate-value-in-project-xml-of-egp-file/m-p/319355#M21414 <P>We are trying to understand&nbsp;the format&nbsp;of the date fields&nbsp;of&nbsp; the tags CreatedOn and ModifiedOn in the project.xml file of the .egp.</P><P>&nbsp;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Element Type="SAS.EG.ProjectElements.EGTask"&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Element&gt;</P><P>. . .</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Type&gt;TASK&lt;/Type&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;Container&gt;1df71fd1-5333-41f1-94e0-031f3e35aa71&lt;/Container&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ....</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;CreatedOn&gt;633239148246822370&lt;/CreatedOn&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;ModifiedOn&gt;633252968775056542&lt;/ModifiedOn&gt;</P><P>&nbsp;</P><P>It is not the normal SAS date time value which is the number of seconds since Jan 1, 1960, as this is too large a value for that.</P><P>Does anyone know how to interpret and convert these date values?</P> Thu, 15 Dec 2016 18:24:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/ModifiedDate-value-in-project-xml-of-egp-file/m-p/319355#M21414 dougcrites 2016-12-15T18:24:55Z https://communities.sas.com/t5/SAS-Enterprise-Guide/ModifiedDate-value-in-project-xml-of-egp-file/m-p/319361#M21416 <P>First, usual caveats for spelunking into the project file: not documented by SAS, and subject to change.</P> <P>&nbsp;</P> <P>Next:</P> <P>I think it's a Microsoft datetime value (as EG is a Windows app), and that's the number of ticks since Jan 1, 0001 AD. &nbsp;Big number! &nbsp;More <A href="http://blogs.sas.com/content/sasdummy/2012/06/14/read-a-microsoft-date-time-value-into-a-sas-date-time-value/" target="_self">here in this blog post, including how to convert to SAS</A>.</P> Thu, 15 Dec 2016 18:53:39 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/ModifiedDate-value-in-project-xml-of-egp-file/m-p/319361#M21416 ChrisHemedinger 2016-12-15T18:53:39Z https://communities.sas.com/t5/SAS-Enterprise-Guide/ModifiedDate-value-in-project-xml-of-egp-file/m-p/319366#M21417 <P>Thanks for such a quick response.. much appreciated!</P> Thu, 15 Dec 2016 19:05:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/ModifiedDate-value-in-project-xml-of-egp-file/m-p/319366#M21417 dougcrites 2016-12-15T19:05:11Z