topic-40027

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

writing date()+time() to Sql Table
Posted: Tue Feb 23, 2021 02:21 PM

To All

I know I have done this before but I just cannot remember how ??

oRs:Fields("Date"):Value := date()+time() does not work

oRs:Fields("Date"):Value := dtoc(Date())+Time() does not work

Thanks
Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: writing date()+time() to Sql Table
Posted: Tue Feb 23, 2021 02:35 PM

To All

Here is the answer ...

oRs:Fields("Date"):Value := DateTime()

Thanks
Rick Lipkin

FiveTech Support Forums