<html><head></head><body><div class="yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div>Hi</div><div>I'm new to the forum so please forgive any mistakes in protocol. I am also pretty new to Gambas and have a lot to learn, so please forgive once again any stupid questions or mistakes.</div><div>Am trying to get Gambas dates to work for me. I have a SQLite3 database and as we know SQLite dates are stored as YYYY-MM-DD. It seems Gambas dates are stored MM-DD-YYYY which in South Africa doesn't work as our local dates are stored dd-mm-yyyy. Now, when I format$ my dateboxes/textboxes to read yyyy-mm-dd, depending on the date, I either get a blank box or the month and day are swopped and therefore also renders the date unusable here. </div><div>My localisation settings for Linux Mint 18.3 KDE are correct.</div><div>How can I convince Gambas to use the local date settings or at least format the date to the 'correct' format for our area?</div><div><br></div><div>The problem occurs when I load the dates from the database and try and format the dates to 'yyyy-mm-dd' using</div><div><span><div> If edtDate.Text Then</div><div> dDate = Val(edtDate.Text)</div><div> edtDate.Text = Format$(dDate, "yyyy-mm-dd")</div><div> Endif</div></span><br></div><div>Any but any suggestions/directions would be much appreciated.</div><div><br></div><div>Thanks</div><div><br></div><div>David</div></div></body></html>