stored procedures and dates

  • Thread starter Thread starter Diavolo
  • Start date Start date
D

Diavolo

Hello i want to use parameter in stored procedure as date, Forms![skolos]![nuo] , but I rescyve error messege:
"Cannot convert entry to valid date/time value".

help me, and sorry for my english
 
Diavolo said:
Hello i want to use parameter in stored procedure as date, Forms![skolos]![nuo] , but I rescyve error messege:
"Cannot convert entry to valid date/time value".

help me, and sorry for my english
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Format() function to change the date to YYYY-MM-DD format and
enclose the result in single-quotes:

"'" & Format(Forms!skolos!nuo, "yyyy-mm-dd") & "'"

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQFIeqoechKqOuFEgEQLiCgCg30UYk/SpbEfrRN3LywHmtkBcAtkAn2xe
4ezDyVS1wb5PAlzQZ4Bafa4D
=Bnz/
-----END PGP SIGNATURE-----
 
Back
Top