• Top Members
    Reps
    Posts
  • 834 Replies
    2585 Replies
  • 716 Replies
    2026 Replies
  • 331 Replies
    1928 Replies

Date issue

User avatar
Dummy1912
VIP - Donator
Posts: 1967

Date issue

Sat Dec 08, 2018 7: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

User avatar
CodenStuff
Site Admin
Posts: 4375

Re: Date issue

Sun Dec 09, 2018 4:18 pm

Have you tried:

Code: Select all

mydate.value.date
Welcome to CodenStuff.com Learn Code, Love Code. Thank you for being a member of the community.


Post Reply

Return to “Help & Support”