What is the syntax for inserting a memory variable dimmed as Date into a table.
For example:

Number = " & numvar & "
Text = '" & textvar & "'
Date = ????

My statement is similar to the following:

Dim mvar1 as Integer
Dim mvar2 as String
Dim mvar3 as Date

mvar1 = Me!text1.value        (Number of Cycles)
mvar2 = Me!text2.value        (Part #)
mvar3 = Me!text3.value        (Production Date)

Insert into mytable(fld1, fld2, fld3) values(" & mvar1 & ", '" & mvar2 "', ????

Any help would be appreciated