<div dir="ltr">If you need only the date use ValueBox with property Type on Date.<br><div>If you need date and time use it on DateTime.</div><div>Remember dates are dates not strings</div><div>See attached project</div><div><br></div><div>Regards</div><div>Gianluigi<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno dom 24 nov 2019 alle ore 17:12 David Silverwood via User <<a href="mailto:user@lists.gambas-basic.org">user@lists.gambas-basic.org</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:13px"><div></div>
<div dir="ltr">actually, this brings me to another issue... what happened to the datebox in 3.14? I have a timebox but no datebox? I assume therefore I should be able to put it back into the toolbox somehow?</div><div><br></div>
</div><div id="gmail-m_6887444422232364815yahoo_quoted_5181860047">
<div style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
<div>
On Sunday, November 24, 2019, 05:23:08 PM GMT+2, T Lee Davidson <<a href="mailto:t.lee.davidson@gmail.com" target="_blank">t.lee.davidson@gmail.com</a>> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">The date is stored in the db as text?<br clear="none">And, edtDate is a TextBox?<br clear="none"><br clear="none"><br clear="none">___<br clear="none">Lee<br clear="none"><br clear="none"><div id="gmail-m_6887444422232364815yqtfd63524"><br clear="none">On 11/24/19 4:33 AM, David Silverwood via User wrote:<br clear="none">> me again-<br clear="none">> I have the strangest thing happening when I load a record in my SQLite database. Gambas reads the dates then subtracts a day. So <br clear="none">> instead of say 2019-11-22 which is the actual date in the db, Gambas loads 2019-11-21. I cannot think that this is supposed to <br clear="none">> happen.<br clear="none">> My code:<br clear="none">> <br clear="none">> Public Sub Button5_Click() ' load the record into a form<br clear="none">> '<br clear="none">> <br clear="none">> Inc Application.Busy<br clear="none">> <br clear="none">> $Request = "SUPPLIER = &1 AND INVOICE_NO = &2"<br clear="none">> <br clear="none">> $Result = conMod.$Con.Edit("Documents", $Request, Trim(cboSupplier.Text), Trim(edtInvoice.Text))<br clear="none">> edtRef.Text = $Result!REF<br clear="none">> edtDate.Text = $Result!DATE ' ... and my date appears one day earlier than it is written in the database... wtf<br clear="none">> cboSupplier.Text = $Result!SUPPLIER<br clear="none">> edtInvoice.Text = $Result!INVOICE_NO<br clear="none">> edtDelivery.Text = $Result!DELIVERY_NOTE<br clear="none">> edtOrder.Text = $Result!ORDER_NO<br clear="none">> cboReceipt.Text = $Result!RECEIVED<br clear="none">> edtAdmin.Text = $Result!ADMIN<br clear="none">> $Result.Update<br clear="none">> <br clear="none">> $Date = Left(edtDate.Text, 10)<br clear="none">> edtDate.Text = Format($Date, "yyyy-mm-dd")<br clear="none">> <br clear="none">> $Date = Left(edtAdmin.Text, 10)<br clear="none">> edtAdmin.Text = Format($Date, "yyyy-mm-dd")<br clear="none">> <br clear="none">> Button1.Enabled = True<br clear="none">> Button3.Enabled = True<br clear="none">> Button4.Enabled = True<br clear="none">> Button2.Enabled = True<br clear="none">> <br clear="none">> Finally<br clear="none">> Dec Application.Busy<br clear="none">> <br clear="none">> Catch<br clear="none">> objErr.dhError()<br clear="none">> <br clear="none">> End<br clear="none">> <br clear="none">> Any assistance will be appreciated.<br clear="none">> <br clear="none">> Thx and regards<br clear="none">> <br clear="none">> David</div><br clear="none">> <br clear="none">> <br clear="none">> <br clear="none">> ----[ Gambas mailing-list is hosted by <a shape="rect" href="https://www.hostsharing.net" target="_blank">https://www.hostsharing.net </a>]----<br clear="none">> <br clear="none"><br clear="none">----[ Gambas mailing-list is hosted by <a shape="rect" href="https://www.hostsharing.net" target="_blank">https://www.hostsharing.net </a><div id="gmail-m_6887444422232364815yqtfd51452">]----<br clear="none"></div></div></div>
</div>
</div></div><br>
----[ Gambas mailing-list is hosted by <a href="https://www.hostsharing.net" rel="noreferrer" target="_blank">https://www.hostsharing.net</a> ]----<br>
</blockquote></div>