https://forge.codesys.com/forge/talk/Engineering/thread/4f408f553e/2020-03-02T15:11:29.330000ZRecent posts to Leap Year error in CAA DTUtils.GetDayOfWeek function2020-03-02T15:11:29.330000Z2020-03-02T15:11:29.330000Ztvmhttps://forge.codesys.com/u/tvm/https://forge.codesys.comc1116246c952247acad2ec7ec30c5df2083f9c14

<div class="markdown_content"><p>For anyone who needs to replace it, here's a function that works</p> <div class="codehilite"><pre><span></span><span class="nt">FUNCTION</span> <span class="nt">DATE_TO_DAY</span> <span class="o">:</span> <span class="nt">INT</span><span class="o">(</span><span class="nt">0</span><span class="o">.</span><span class="p">.</span><span class="nc">6</span><span class="o">)</span> <span class="nt">VAR_INPUT</span> <span class="nt">DateIn</span><span class="o">:</span> <span class="nt">DATE</span><span class="o">;</span> <span class="nt">END_VAR</span> <span class="nt">VAR</span> <span class="nt">CONSTANT</span> <span class="nt">SECONDS_PER_DAY</span><span class="o">:</span> <span class="nt">DINT</span><span class="o">:=</span> <span class="nt">24</span><span class="o">*</span><span class="nt">60</span><span class="o">*</span><span class="nt">60</span><span class="o">;</span> <span class="o">//</span><span class="nt">number</span> <span class="nt">of</span> <span class="nt">seconds</span> <span class="nt">in</span> <span class="nt">a</span> <span class="nt">day</span> <span class="nt">EPOCH_STARTDAY</span><span class="o">:</span> <span class="nt">DINT</span><span class="o">:=</span> <span class="nt">4</span><span class="o">;</span> <span class="o">//</span><span class="nt">DATE</span> <span class="nt">variable</span> <span class="nt">is</span> <span class="nt">stored</span> <span class="nt">as</span> <span class="nt">seconds</span> <span class="nt">since</span> <span class="nt">Jan</span> <span class="nt">1</span><span class="o">,</span> <span class="nt">1970</span><span class="o">,</span> <span class="nt">which</span> <span class="nt">was</span> <span class="nt">a</span> <span class="nt">Thursday</span> <span class="nt">END_VAR</span> <span class="o">(*====================================================================================</span> <span class="nt">DATE_TO_DAY</span> <span class="nt">Calculate</span> <span class="nt">day</span> <span class="nt">of</span> <span class="nt">week</span> <span class="nt">from</span> <span class="nt">date</span> <span class="nt">Sunday</span><span class="o">=</span><span class="nt">0</span><span class="o">,</span> <span class="nt">Saturday</span><span class="o">=</span><span class="nt">6</span> <span class="o">======================================================================================*)</span> <span class="nt">DATE_TO_DAY</span> <span class="o">:=</span> <span class="nt">DINT_TO_INT</span><span class="o">(((</span><span class="nt">DATE_TO_DINT</span><span class="o">(</span><span class="nt">DateIn</span><span class="o">)</span> <span class="o">/</span> <span class="nt">SECONDS_PER_DAY</span><span class="o">)</span> <span class="o">+</span> <span class="nt">EPOCH_STARTDAY</span><span class="o">)</span> <span class="nt">MOD</span> <span class="nt">7</span><span class="o">);</span> </pre></div> </div>

2020-03-02T13:11:50.743000Z2020-03-02T13:11:50.743000Ztvmhttps://forge.codesys.com/u/tvm/https://forge.codesys.com79ae6b4730872ffc387af7e774c01e19a6777ecb

<div class="markdown_content"><p>@ThK you seem to have access to this developer database. Can you explain why this kind of information is not publicly available? I used the CAA library because I made the assumption that a date and time utility would have been tested against dates and times, leap years being one of the most obvious tests. Knowing that it doesn't work, I don't see the use of it--I might as well write my own function.</p></div>

2020-03-02T08:16:21.990000Z2020-03-02T08:16:21.990000ZThKhttps://forge.codesys.com/u/thk/https://forge.codesys.comf7c1148842ab2af8440026cb0ad2f52361d17063

<div class="markdown_content"><p>Hi,<br/> Yes, it is an known bug. <br/> The entry in our developer database is:<br/> CDS-47688: Library: CAA DTUtility GetDayOfWeek returns wrong weekday for leap day </p> <p>Regards Thomas</p></div>

2020-02-29T16:45:13.608000Z2020-02-29T16:45:13.608000Ztvmhttps://forge.codesys.com/u/tvm/https://forge.codesys.com777c0e6879d23067a6fc15a7351fbf498ad7a151

<div class="markdown_content"><p>I believe I have found an error in the CAA DTUtils GetDayOfWeek function. According to the documentation, it should return 0-6 for days of the week, Sunday-Saturday. Today, I'm getting a return value of 7, and an error of DTU_ERROR_UNKNOWN.<br/> I have library version 3.5.12.0. Anyone else have this problem?<br/> <img src="./attachment/attachment.png" width="50%"/></p></div>