[Gambas-user] DATE function Gambas 3.8.4 (Distro)

Charlie Ogier charlie at cogier.com
Mon Apr 29 18:12:13 CEST 2019

Hi David,

Try this code: -

Dim dDate As Date
Dim sDate As New String[]

edtDate.Text = "2019-04-29"         'I presume this is the format you 
get so you can take this line out. It was for me to test.

If edtDate.Text Then
   sDate = Split(edtDate.Text, "-")
   dDate = Date(sDate[0], sDate[1], sDate[2])
   edtDate.Text = Format$(dDate, "dd/mm/yyyy")

If you use the ppa you can have the latest version of Gambas. Run the 
following command in Terminal and Gambas 3.13.0 will install. You will 
need a reasonable internet connection.

sudo add-apt-repository -y ppa:gambas-team/gambas3 && sudo apt-get 
update && sudo apt-get -y install gambas3

Hope that helps,


On 29/04/2019 14:40, David Silverwood via User wrote:
> Hi
> 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.
> 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.
> My localisation settings for Linux Mint 18.3 KDE are correct.
> How can I convince Gambas to use the local date settings or at least 
> format the date to the 'correct' format for our area?
> The problem occurs when I load the dates from the database and try and 
> format the dates to 'yyyy-mm-dd' using
>   If edtDate.Text Then
>     dDate = Val(edtDate.Text)
>     edtDate.Text = Format$(dDate, "yyyy-mm-dd")
>   Endif
> Any but any suggestions/directions would be much appreciated.
> Thanks
> David
> ----[ Gambas mailing-list is hosted by https://www.hostsharing.net ]----

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20190429/49e8b7e8/attachment.html>

More information about the User mailing list