<div dir="ltr"><div dir="ltr">Try the attached project</div><div dir="ltr"><br></div><div>Regards</div><div>Gianluigi<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno gio 16 mag 2019 alle ore 19:45 Gianluigi <<a href="mailto:bagonergi@gmail.com">bagonergi@gmail.com</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 dir="ltr"><div dir="ltr">I'm not talking about using dates like Strings (Cogier) but using dates as Dates.<br>This was taught to me by Fabien Bodard (here) and Sotema in Italy.<br>If you always use the Date value for your calculations you will have no problems.<br>Then when you need to show it to the user use Str or Format.</div><div dir="ltr"><br></div><div>Regards</div><div>Gianluigi<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno gio 16 mag 2019 alle ore 19:32 Gianluigi <<a href="mailto:bagonergi@gmail.com" target="_blank">bagonergi@gmail.com</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 dir="ltr"><div dir="ltr">You can write the Date value like this:<br>hResult!usdat = hDate ' ReportTest<br>And you can read it like this:<br>Left(Str(hDate), 10) '(international)<br>Or<br>Format(hDate, "dd/mm/yyyy") '(Local)</div><div dir="ltr"><br></div><div>Regards</div><div>Gianluigi<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno gio 16 mag 2019 alle ore 18:48 David Silverwood via User <<a href="mailto:user@lists.gambas-basic.org" target="_blank">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 class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp93937884yahoo-style-wrap" style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:13px"><div></div>
<div>and if I use today's date I get the following error...</div><div><div>
<p style="margin:0px">'Error 21 in FExpenses.btnLoad_Click.143</p>
<p style="margin:0px">The following error has occurred:</p>
<div style="margin:0px">Out of bounds'</div></div><div style="margin:0px"><br></div><div style="margin:0px">I think its stating that the month cannot be 16 and therefore out of bounds because I do not get this error when I use say 2019-05-05/ 2019-09-12 etc. As I said, my textbox swops the month and day around.</div><div style="margin:0px"><br></div><div style="margin:0px">Please bear with me. I am currently learning Gambas.</div><br></div><div><br></div>
</div><div id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yahoo_quoted_8935663322" class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yahoo_quoted">
<div style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
<div>
On Thursday, May 16, 2019, 6:40:08 PM GMT+2, David Silverwood via User <<a href="mailto:user@lists.gambas-basic.org" target="_blank">user@lists.gambas-basic.org</a>> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788"><div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydpdd45f520yahoo-style-wrap" style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:13px"><div></div>
<div>To add</div><div><br clear="none"></div><div>if I do this, which I have also tried, it comes close but still swops the month and day around...</div><div><br clear="none"></div><div><div><div> If edtDate.Text Then</div><div> sDate = Left$(edtDate.Text, 10)</div><div> $Date = Split(sDate, "/")</div><div> Debug sDate = $Date[2] & "-" & $Date[1] & "-" & $Date[0]</div><div> edtDate.Text = sDate</div><div> Endif</div></div><br clear="none"></div><div>Changing $Date[1] and $Date[0] around makes no difference whatsoever</div><div><br clear="none"></div><div>Regards</div><div><br clear="none"></div><div>David</div><div><br clear="none"></div>
</div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yahoo_quoted" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yahoo_quoted_8781085714">
<div style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
<div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788yqt5179636273" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788yqt11540"><div>
On Thursday, May 16, 2019, 6:31:07 PM GMT+2, David Silverwood via User <<a href="mailto:user@lists.gambas-basic.org" target="_blank">user@lists.gambas-basic.org</a>> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808"><div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp2d98c143yahoo-style-wrap" style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:13px"><div></div>
<div>Hi Gianluigi</div><div><br clear="none"></div><div>Are you referring to this portion:</div><div><div><div> Randomize</div><div> $hConn.Begin()</div><div> For i = 0 To $nRecords</div><div> nCasual = Rand(0, 30)</div><div> sName = aFirstName[nCasual]</div><div> nCasual = Rand(0, 30)</div><div> sSurname = aLastName[nCasual]</div><div> y = Rand(1959, 2000)</div><div> m = Rand(1, 12)</div><div> d = Rand(1, 28)</div><div> hDate = Date(y, m, d)</div><div> hResult = $hConn.Create("tuser")</div><div> hResult!usnam = sName</div><div> hResult!ussur = sSurname</div><div> hResult!usdat = hDate</div><div> hResult.Update</div><div> Next</div></div><br clear="none"></div><div>I actually found the code difficult to decipher but looking at it again I assume you are referring to hDate = Date(y, m, d)?</div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="none"></div>
</div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yahoo_quoted" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yahoo_quoted_8936458258">
<div style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
<div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808yqt5353588679" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808yqt00136"><div>
On Thursday, May 16, 2019, 6:25:09 PM GMT+2, Gianluigi <<a href="mailto:bagonergi@gmail.com" target="_blank">bagonergi@gmail.com</a>> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451"><div><div dir="ltr"><div dir="ltr"><div dir="ltr">I had shown you the correct code you need to look at in Report1.</div><div dir="ltr"><br clear="none"></div><div>Regards</div><div>Gianluigi<br clear="none"></div><br clear="none"><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_quote"><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451yqt9809881283" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451yqtfd95352"><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_attr" dir="ltr">Il giorno gio 16 mag 2019 alle ore 16:17 David Silverwood via User <<a shape="rect" href="mailto:user@lists.gambas-basic.org" rel="nofollow" target="_blank">user@lists.gambas-basic.org</a>> ha scritto:<br clear="none"></div><blockquote class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydp6791a4fdyahoo-style-wrap" style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:13px"><div></div>
<div>Ok, so I'm back with the same problem. It seems to me Gambas has a template format for a date and trying to change it is impossible? As soon as Gambas sees it as a date, it reformats my formatting back to the incorrect format and renders all the code useless. Is this the way it is supposed to be? </div><div><br clear="none"></div><div>I need my date formatted to sqlite format, eg, yyyy-mm-dd</div><div><br clear="none"></div><div>However, soon as I do that, gambas switches it to mm/dd/yyyy.</div><div><br clear="none"></div><div>My OS regional settings are correct. Using Mint 18.3 KDE and Gambas 3.13 (Thanks Charlie for the upgrade tip)</div><div><br clear="none"></div><div>The latter format is useless over here and inevitably gambas reads the day and month wrong, by switching it... I've tried using Split and in a debug /print statement I see that it does do exactly what I need, but once the format hits the textbox, Gambas actually changes it back to mm/dd/yyyy. How do I stop that? I tried DIM'ing the dates as Strings but Gambas seems to read dates as dates even if they are dimensioned as strings? (which I know they are 'special' strings of course).</div><div><br clear="none"></div><div>My sqlite3 database complains whenever I try and save the dates in Gambas's preferred format.</div><div><br clear="none"></div><div>I know I am doing something wrong since no one else has this issue.... but what?</div><div><br clear="none"></div><div><br clear="none"></div><div><br clear="none"></div>
</div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yahoo_quoted" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yahoo_quoted_8492039099">
<div>
<div>
On Tuesday, April 30, 2019, 11:05:06 AM GMT+2, David Silverwood via User <<a shape="rect" href="mailto:user@lists.gambas-basic.org" rel="nofollow" target="_blank">user@lists.gambas-basic.org</a>> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yiv7748707307"><div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yiv7748707307ydp65c9a003yahoo-style-wrap" style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:13px"><div></div>
<div>Thank you very much Charlie and Gianluigi. Those were pointers in the right direction for me! I really appreciate your help. (Not to mention I just learned a lot from both of your code too.)</div><div><br clear="none"></div></div></div></div></div></div></div></div></blockquote></div></div></div></div></div></div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yqt9809881283" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yqtfd17783"><br clear="none">----[ Gambas mailing-list is hosted by <a shape="rect" href="https://www.hostsharing.net" rel="nofollow" target="_blank">https://www.hostsharing.net </a>]----<br clear="none"></div></div></div>
</div>
</div></div></div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yqt5353588679" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yiv5712419788ydp570e079yqt46446"><br clear="none">----[ Gambas mailing-list is hosted by <a shape="rect" href="https://www.hostsharing.net" rel="nofollow" target="_blank">https://www.hostsharing.net </a>]----<br clear="none"></div></div></div>
</div>
</div></div></div><div class="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yqt5179636273" id="gmail-m_8495387154210840872gmail-m_-7971304339891501973gmail-m_-39847443341260801ydp47a0b0f2yqt89443"><br clear="none">----[ Gambas mailing-list is hosted by <a shape="rect" href="https://www.hostsharing.net" rel="nofollow" target="_blank">https://www.hostsharing.net </a>]----<br clear="none"></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>
</blockquote></div>
</blockquote></div>