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

Thu May 16 23:34:01 CEST 2019

Try the attached project

Regards
Gianluigi

Il giorno gio 16 mag 2019 alle ore 19:45 Gianluigi <bagonergi at gmail.com> ha
scritto:

> I'm not talking about using dates like Strings (Cogier) but using dates as
> Dates.
> This was taught to me by Fabien Bodard (here) and Sotema in Italy.
> If you always use the Date value for your calculations you will have no
> problems.
> Then when you need to show it to the user use Str or Format.
>
> Regards
> Gianluigi
>
> Il giorno gio 16 mag 2019 alle ore 19:32 Gianluigi <bagonergi at gmail.com>
> ha scritto:
>
>> You can write the Date value like this:
>> hResult!usdat = hDate ' ReportTest
>> And you can read it like this:
>> Left(Str(hDate), 10) '(international)
>> Or
>> Format(hDate, "dd/mm/yyyy") '(Local)
>>
>> Regards
>> Gianluigi
>>
>> Il giorno gio 16 mag 2019 alle ore 18:48 David Silverwood via User <
>> user at lists.gambas-basic.org> ha scritto:
>>
>>> and if I use today's date I get the following error...
>>>
>>> 'Error 21 in FExpenses.btnLoad_Click.143
>>>
>>> The following error has occurred:
>>> Out of bounds'
>>>
>>> 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.
>>>
>>> Please bear with me. I am currently learning Gambas.
>>>
>>>
>>> On Thursday, May 16, 2019, 6:40:08 PM GMT+2, David Silverwood via User <
>>> user at lists.gambas-basic.org> wrote:
>>>
>>>
>>> To add
>>>
>>> if I do this, which I have also tried, it comes close but still swops
>>> the month and day around...
>>>
>>>     If edtDate.Text Then
>>>         sDate = Left$(edtDate.Text, 10)
>>>         $Date = Split(sDate, "/")
>>>         Debug sDate = $Date[2] & "-" & $Date[1] & "-" & $Date[0]
>>>         edtDate.Text = sDate
>>>     Endif
>>>
>>> Changing $Date[1] and $Date[0] around makes no difference whatsoever
>>>
>>> Regards
>>>
>>> David
>>>
>>> On Thursday, May 16, 2019, 6:31:07 PM GMT+2, David Silverwood via User <
>>> user at lists.gambas-basic.org> wrote:
>>>
>>>
>>> Hi Gianluigi
>>>
>>> Are you referring to this portion:
>>>  Randomize
>>>   $hConn.Begin()
>>>   For i = 0 To $nRecords
>>>     nCasual = Rand(0, 30)
>>>     sName = aFirstName[nCasual]
>>>     nCasual = Rand(0, 30)
>>>     sSurname = aLastName[nCasual]
>>>     y = Rand(1959, 2000)
>>>     m = Rand(1, 12)
>>>     d = Rand(1, 28)
>>>     hDate = Date(y, m, d)
>>>     hResult = $hConn.Create("tuser")
>>>     hResult!usnam = sName
>>>     hResult!ussur = sSurname
>>>     hResult!usdat = hDate
>>>     hResult.Update
>>>   Next
>>>
>>> I actually found the code difficult to decipher but looking at it again
>>> I assume you are referring to hDate = Date(y, m, d)?
>>>
>>>
>>>
>>> On Thursday, May 16, 2019, 6:25:09 PM GMT+2, Gianluigi <
>>> bagonergi at gmail.com> wrote:
>>>
>>>
>>> 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.)
>>>
>>>
>>> ----[ Gambas mailing-list is hosted by https://www.hostsharing.net ]----
>>>
>>> ----[ Gambas mailing-list is hosted by https://www.hostsharing.net ]----
>>>
>>> ----[ Gambas mailing-list is hosted by https://www.hostsharing.net ]----
>>>
>>> ----[ 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/20190516/bf913b11/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SQLiteDateTest-0.0.1.tar.gz
Type: application/gzip
Size: 11986 bytes
Desc: not available
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20190516/bf913b11/attachment-0001.gz>