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

[David Silverwood]

 Hi Charlie
I also suspected it should work, but nope. I saved a screenshot of the result which I will attach.
This was the code:    If edtDate.Text Then        sDate = Left$(edtDate.Text, 10)        $Date = Split(sDate, "/")        dDate = Date($Date[2], $Date[0], $Date[1])        edtDate.Text = Format$(dDate, "yyyy-mm-dd")    Endif
Maybe it has something to do with the OS itself? My regional settings seem correct...

    On Thursday, May 16, 2019, 8:13:08 PM GMT+2, Charlie Ogier <charlie at cogier.com> wrote:  
 
  Hi David,
 
 What are you getting from the database as the following code works: -
 
 Public Sub Form_Open()
 Dim dDate As Date
 Dim sDate As New String[]
 
 edtDate.Text = "05/16/2019"                             ''Is this what you get??
 
  If edtDate.Text Then
     edtDate.Text = Left(edtDate.Text, 10)
    sDate = Split(edtDate.Text, "/")
    dDate = Date(sDate[2], sDate[0], sDate[1])
    edtDate.Text = Format$(dDate, "yyyy-mm-dd")          'Result: 2019-05-16
    edtDate2.Text = Format$(dDate, "dd-mm-yyyy")         'Result: 16-05-2019
    edtDate3.Text = Format$(dDate, "dddd dd mmmm yyyy")  'Result: Thursday 16 May 2019
 Endif
 
 End
 
 
 Charlie 
 
 On 16/05/2019 17:47, David Silverwood via User wrote:
  
 
 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 ]----
 
 
----[ 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/e99f44f5/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot_20190516_202950.png
Type: image/png
Size: 135772 bytes
Desc: not available
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20190516/e99f44f5/attachment-0001.png>