how do i define variable Date in Visual Basic?
Posted on 2014-08-01
i have the following select statement:
" select invoiceno, invoicedate, sent_810, sent_211 as sent_mail from invheader where (sent_211 = 'N' or sent_211 is null) and (sent_810 = 'N' or sent_810 is null) and invoicedate between ? and ? "
' On Error GoTo UserError:
fpick = InputBox("Select First Invoice# in Range")
comm.Parameters(0) = fpick
lpick = InputBox("Select Last Invoice# in Range")
comm.Parameters(1) = lpick
i am receiving error when entering the date to message box
i know that the type is incorrect what should be the right type that the select will run fine with date?