<div dir="ltr"><div>I'm not sure why the previous, more consistent behavior, was considered a bug, and why it's deemed better now that it's 'fixed', and different date functions behave differently, and are incompatible with each other. <br></div><div><br></div><div> I have an application that makes extensive use of dates and date calculations, which has worked just fine for years. But now the bug fix has seriously broken things. I started to kludge some of the code to make it work, but I could see I was heading down a rat-hole. So in the end I migrated it to .NET instead.<br></div><div><br></div><div>Just my $0.02</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, May 19, 2018 at 2:43 PM, T Lee Davidson <span dir="ltr"><<a href="mailto:t.lee.davidson@gmail.com" target="_blank">t.lee.davidson@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I don't get that 5 minute anomaly. With three blocks each defining zTestDate through Debug (Print), I get:<br>
Main.Main.9: Test date: 5/4/2018 Formatted: 05/03/18 20:00 Thu<br>
Main.Main.12: Test date: 5/4/2018 03:59:00 Formatted: 05/03/18 23:59 Thu<br>
Main.Main.15: Test date: 5/4/2018 04:00:00 Formatted: 05/04/18 00:00 Fri<br>
<br>
<br>
On 05/19/2018 01:48 PM, George wrote:<br>
> (This was originally posted in <a href="mailto:gambas-user@lists.sourceforge.net">gambas-user@lists.sourceforge.<wbr>net</a> <mailto:<a href="mailto:gambas-user@lists.sourceforge.net">gambas-user@lists.<wbr>sourceforge.net</a>><br>
<span class="">> I've since seen that list has been deprecated, so I'm reposting the pertinent issues here)<br>
> <br>
> When using the Format function to format a date, the date gets offset by 1 day. Here's an example:<br>
> <br>
> Dim zTestDate As String<br>
> Dim zTestResult As String<br>
> zTestDate = "5/4/2018"<br>
> zTestResult = Format(CDate(zTestDate), "mm/dd/yy ddd")<br>
> Debug "Test date: " & zTestDate & " Formatted: " & zTestResult<br>
> <br>
> Result: Test date: 5/4/2018 Formatted: 05/03/18 Thu<br>
> <br>
> This seems to have started since the last update was applied.<br>
> <br>
</span>>>T Lee Davidson <<a href="mailto:t.lee.davidson@gmail.com">t.lee.davidson@gmail.com</a> <mailto:<a href="mailto:t.lee.davidson@gmail.com">t.lee.davidson@gmail.<wbr>com</a>>><br>
<span class="im HOEnZb">>><br>
>>CDate uses UTC and, without the time information in the string, it would store midnight. Format uses local time.<br>
>><br>
>>So, anyone in a time zone behind UTC will get the previous day printed. Try this format string:<br>
>>zTestResult = Format(CDate(zTestDate), "mm/dd/yy hh:nn ddd")<br>
>><br>
>>Does the difference in hours match your timezone offset?<br>
> <br>
> That is definitely part of the issue. My local time is GMT-04, and here's what I get when specifying the time in my test:<br>
> <br>
> Test date: 5/4/2018 03:59:00 Formatted: 05/03/18 Thu<br>
> Test date: 5/4/2018 04:00:00 Formatted: 05/04/18 Fri<br>
> <br>
> However, if I look at time in the results, the difference isn't exactly the offset:<br>
> Test date: 5/4/2018 03:59:00 Formatted: 05/03/18 23:05:00 Difference: 4:54:00<br>
> Test date: 5/4/2018 04:00:00 Formatted: 05/04/18 00:05:00 Difference: 3:55:00<br>
> Test date: 5/4/2018 00:00:00 Formatted: 05/03/18 20:05:00 Difference: 3:55:00<br>
> <br>
> The offset isn't an even number of hours. What's also odd is that this was never a problem before about a week ago. This code<br>
> is many years old, and the problem suddenly began occurring with compiled code.<br>
> <br>
> <br>
> <br>
> <br>
</span><span class="im HOEnZb">> ----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
> <br>
<br>
</span><span class="HOEnZb"><font color="#888888">-- <br>
Lee<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
</div></div></blockquote></div><br></div>