{ Learn Code. Share Code. Teach Code. Love Code. }

  • Date issue

 #84455  by Dummy1912
 Sat Dec 08, 2018 6:56 pm
Hello,

please i need some help
i can't save the date from a datetimepicker into our db

it keeps blank
Code: Select all
        Planner.mdlProcedures.modifyDatabase("INSERT INTO historypayments VALUES (null, " & Util.quote(6) & ", " & Util.quote(mydate.value) & ", " & Util.quote(1) & ", " & Util.quote(0) & ");")

DB:
Code: Select all
CREATE TABLE [HistoryPayments] (
[mid] INTEGER  PRIMARY KEY AUTOINCREMENT NULL,
[mnum] INTEGER  NULL,
[mdate] DATE  NULL,
[mstatus] INTEGER DEFAULT '1' NULL,
[mskip] INTEGER  NULL
)
Thank you
 #84456  by CodenStuff
 Sun Dec 09, 2018 3:18 pm
Have you tried:
Code: Select all
mydate.value.date