Say I was to assign a variable named myDate the value of now(). How could I then make 'myDate' the value of a field for a database(sql)?
Why dont you just save now() in the Db<BR><BR>if you wnat to <BR><BR>mydate = now()<BR><BR>"insert into tableName values ('" & mydate & "')<BR><BR>if you are using access use # instead of '
A, What would the exact line be if my variable is entryDate and my table is named IPP_Table and the field name DateEntered?
insert into IPP_Table DateEntered values ('" & entryDate & "')"