<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></div><div>Regards</div><div>Gianluigi<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno gio 16 mag 2019 alle ore 16:17 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 class="gmail-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></div><div>I need my date formatted to sqlite format, eg, yyyy-mm-dd</div><div><br></div><div>However, soon as I do that, gambas switches it to mm/dd/yyyy.</div><div><br></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></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></div><div>My sqlite3 database complains whenever I try and save the dates in Gambas's preferred format.</div><div><br></div><div>I know I am doing something wrong since no one else has this issue.... but what?</div><div><br></div><div><br></div><div><br></div>
</div><div id="gmail-m_-4058040158495589322ydpe15f8925yahoo_quoted_8492039099" class="gmail-m_-4058040158495589322ydpe15f8925yahoo_quoted">
<div style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
<div>
On Tuesday, April 30, 2019, 11:05:06 AM 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_-4058040158495589322ydpe15f8925yiv7748707307"><div><div class="gmail-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>