<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi David,<br>
<br>
What are you getting from the database as the following code
works: -<br>
<br>
<i><b>Public Sub Form_Open()</b></i><i><b><br>
</b></i><i><b>Dim dDate As Date</b></i><i><b><br>
</b></i><i><b>Dim sDate As New String[]</b></i><i><b><br>
</b></i><i><b><br>
</b></i><i><b>edtDate.Text =
"05/16/2019" ''Is this what you
get??</b></i><i><b><br>
</b></i><i><b><br>
</b></i><i><b> If edtDate.Text Then</b></i><i><b><br>
</b></i><i><b> edtDate.Text = Left(edtDate.Text, 10)</b></i><i><b><br>
</b></i><i><b> sDate = Split(edtDate.Text, "/")</b></i><i><b><br>
</b></i><i><b> dDate = Date(sDate[2], sDate[0], sDate[1])</b></i><i><b><br>
</b></i><i><b> edtDate.Text = Format$(dDate,
"yyyy-mm-dd") 'Result: 2019-05-16</b></i><i><b><br>
</b></i><i><b> edtDate2.Text = Format$(dDate,
"dd-mm-yyyy") 'Result: 16-05-2019</b></i><i><b><br>
</b></i><i><b> edtDate3.Text = Format$(dDate, "dddd dd mmmm
yyyy") 'Result: Thursday 16 May 2019</b></i><i><b><br>
</b></i><i><b>Endif</b></i><i><b><br>
</b></i><i><b><br>
</b></i><i><b>End</b></i><i><b><br>
</b></i><br>
<br>
Charlie <br>
<br>
On 16/05/2019 17:47, David Silverwood via User wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1540864515.1330483.1558025236446@mail.yahoo.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="ydp93937884yahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:13px;">
<div>and if I use today's date I get the following error...</div>
<div>
<div>
<p style="margin: 0px;"><!--StartFragment-->'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="ydp47a0b0f2yahoo_quoted_8935663322"
class="ydp47a0b0f2yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial,
sans-serif;font-size:13px;color:#26282a;">
<div> On Thursday, May 16, 2019, 6:40:08 PM GMT+2, David
Silverwood via User <a class="moz-txt-link-rfc2396E" href="mailto:user@lists.gambas-basic.org"><user@lists.gambas-basic.org></a>
wrote: </div>
<div><br>
</div>
<div><br>
</div>
<div>
<div id="ydp47a0b0f2yiv5712419788">
<div>
<div
class="ydp47a0b0f2yiv5712419788ydpdd45f520yahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:13px;">
<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="ydp47a0b0f2yiv5712419788ydp570e079yahoo_quoted"
id="ydp47a0b0f2yiv5712419788ydp570e079yahoo_quoted_8781085714">
<div style="font-family:'Helvetica Neue', Helvetica,
Arial, sans-serif;font-size:13px;color:#26282a;">
<div class="ydp47a0b0f2yiv5712419788yqt5179636273"
id="ydp47a0b0f2yiv5712419788yqt11540">
<div> On Thursday, May 16, 2019, 6:31:07 PM GMT+2,
David Silverwood via User
<a class="moz-txt-link-rfc2396E" href="mailto:user@lists.gambas-basic.org"><user@lists.gambas-basic.org></a> wrote: </div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
<div>
<div
id="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808">
<div>
<div
class="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp2d98c143yahoo-style-wrap"
style="font-family:Helvetica Neue,
Helvetica, Arial,
sans-serif;font-size:13px;">
<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="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yahoo_quoted"
id="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yahoo_quoted_8936458258">
<div style="font-family:'Helvetica Neue',
Helvetica, Arial,
sans-serif;font-size:13px;color:#26282a;">
<div
class="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808yqt5353588679"
id="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808yqt00136">
<div> On Thursday, May 16, 2019,
6:25:09 PM GMT+2, Gianluigi
<a class="moz-txt-link-rfc2396E" href="mailto:bagonergi@gmail.com"><bagonergi@gmail.com></a> wrote: </div>
<div><br clear="none">
</div>
<div><br clear="none">
</div>
<div>
<div
id="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451">
<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="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_quote">
<div
class="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451yqt9809881283"
id="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451yqtfd95352">
<div
class="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_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"
moz-do-not-send="true">user@lists.gambas-basic.org</a>>
ha scritto:<br
clear="none">
</div>
<blockquote
class="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail_quote"
style="margin:0px 0px
0px
0.8ex;border-left:1px
solid
rgb(204,204,204);padding-left:1ex;">
<div>
<div
class="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydp6791a4fdyahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:13px;">
<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="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yahoo_quoted"
id="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-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" moz-do-not-send="true">user@lists.gambas-basic.org</a>>
wrote: </div>
<div><br
clear="none">
</div>
<div><br
clear="none">
</div>
<div>
<div
id="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yiv7748707307">
<div>
<div
class="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yiv5976075451gmail-m_-4058040158495589322ydpe15f8925yiv7748707307ydp65c9a003yahoo-style-wrap"
style="font-family:Helvetica Neue, Helvetica, Arial,
sans-serif;font-size:13px;">
<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="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yqt9809881283"
id="ydp47a0b0f2yiv5712419788ydp570e079yiv6465630808ydp655bf3c8yqtfd17783"><br
clear="none">
----[ Gambas mailing-list is
hosted by <a shape="rect"
href="https://www.hostsharing.net
" rel="nofollow" target="_blank"
moz-do-not-send="true">https://www.hostsharing.net
</a>]----<br clear="none">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div
class="ydp47a0b0f2yiv5712419788ydp570e079yqt5353588679"
id="ydp47a0b0f2yiv5712419788ydp570e079yqt46446"><br clear="none">
----[ Gambas mailing-list is hosted by <a
shape="rect"
href="https://www.hostsharing.net "
rel="nofollow" target="_blank"
moz-do-not-send="true">https://www.hostsharing.net
</a>]----<br clear="none">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="ydp47a0b0f2yqt5179636273"
id="ydp47a0b0f2yqt89443"><br clear="none">
----[ Gambas mailing-list is hosted by <a shape="rect"
href="https://www.hostsharing.net " rel="nofollow"
target="_blank" moz-do-not-send="true">https://www.hostsharing.net
</a>]----<br clear="none">
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">
----[ Gambas mailing-list is hosted by <a class="moz-txt-link-freetext" href="https://www.hostsharing.net">https://www.hostsharing.net</a> ]----
</pre>
</blockquote>
<br>
</body>
</html>