writing date()+time() to Sql Table

[Rick Lipkin]

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

[Rick Lipkin]

To All

Here is the answer ...

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

Thanks
Rick Lipkin