https://forge.codesys.com/forge/talk/Engineering/thread/bd1b7951c1/2020-02-27T13:48:17.578000ZRecent posts to File .csv in Trace Recorder2020-02-27T13:48:17.578000Z2020-02-27T13:48:17.578000Zk2teknikhttps://forge.codesys.com/u/k2teknik/https://forge.codesys.comd0ed8ccde483ffe2f219e2efa0f249dcea999a2f

<div class="markdown_content"><blockquote> <p><strong>Domingo hat geschrieben:</strong><br/> For example, today This number should indicate today date and time (04/10/2016).<br/> How can I decode this number?<br/> It must be Unix date (and time) format, but I think you are missing a zero?<br/> 147557616 gives: "<span style="color: #0000FF;">Wed, 04 Sep 1974 20:13:36 GMT</span>"<br/> 1475576160 gives: <span style="color: #0000FF;">"Tue, 04 Oct 2016 10:16:00 GMT</span>"</p> </blockquote> <p>So in excel you have your unix date (date and time stamp it is) in cell A1 and in an other cell (that you format as date) type: <span style="color: #BF0000;">=A1/(60<em>60</em>24)+"1/1/1970"</span></p></div>

2020-02-27T13:48:17.504000Z2020-02-27T13:48:17.504000ZDomingohttps://forge.codesys.com/u/domingo/https://forge.codesys.com89aeea164e79c2dad812048bf33665df77e3c7b7

<div class="markdown_content"><p>Hi,<br/> I use Codesys V3.5 SP8 Patch 2.<br/> With trace recorder I write a file in .csv with the values of two variables and then use it in Excel.<br/> Field Trigger.Date writes the date/time in a format that I cannot turn with Excel.<br/> For example, today <strong>Trigger.Data; 147557616 </strong>This number should indicate today date and time (04/10/2016).<br/> How can I decode this number?<br/> Thanks to all.</p></div>