<html><head></head><body><div class="ydpdd45f520yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div>To add</div><div><br></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></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></div><div>Changing $Date[1] and $Date[0] around makes no difference whatsoever</div><div><br></div><div>Regards</div><div><br></div><div>David</div><div><br></div>
</div><div id="ydp570e079yahoo_quoted_8781085714" class="ydp570e079yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, May 16, 2019, 6:31:07 PM GMT+2, David Silverwood via User <user@lists.gambas-basic.org> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp570e079yiv6465630808"><div><div class="ydp570e079yiv6465630808ydp2d98c143yahoo-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="ydp570e079yiv6465630808ydp655bf3c8yahoo_quoted" id="ydp570e079yiv6465630808ydp655bf3c8yahoo_quoted_8936458258">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div class="ydp570e079yiv6465630808yqt5353588679" id="ydp570e079yiv6465630808yqt00136"><div>
On Thursday, May 16, 2019, 6:25:09 PM GMT+2, Gianluigi <bagonergi@gmail.com> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451"><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="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_quote"><div class="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451yqt9809881283" id="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451yqtfd95352"><div class="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_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="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div><div class="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-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="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yahoo_quoted" id="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-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="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yiv7748707307"><div><div class="ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-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="ydp570e079yiv6465630808ydp655bf3c8yqt9809881283" id="ydp570e079yiv6465630808ydp655bf3c8yqtfd17783"><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="ydp570e079yqt5353588679" id="ydp570e079yqt46446"><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></body></html>