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

[Gianluigi]

I had shown you the correct code you need to look at in Report1.

Regards
Gianluigi

Il giorno gio 16 mag 2019 alle ore 16:17 David Silverwood via User <
user at lists.gambas-basic.org> ha scritto:

> 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?
>
> I need my date formatted to sqlite format, eg, yyyy-mm-dd
>
> However, soon as I do that, gambas switches it to mm/dd/yyyy.
>
> My OS regional settings are correct. Using Mint 18.3 KDE and Gambas 3.13
> (Thanks Charlie for the upgrade tip)
>
> 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).
>
> My sqlite3 database complains whenever I try and save the dates in
> Gambas's preferred format.
>
> I know I am doing something wrong since no one else has this issue.... but
> what?
>
>
>
> On Tuesday, April 30, 2019, 11:05:06 AM GMT+2, David Silverwood via User <
> user at lists.gambas-basic.org> wrote:
>
>
> 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.)
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20190516/5790900c/attachment.html>