I want to ALSO insert into TABLE1 in the field name "signupdate" the signupdate which is "AZDATE".
I know I have to add it here....Code:sql= "insert into TABLE1 (CustomerID,productid)select customerid,productid from TABLE2,TABLE3 where TABLE2.customername = '"& customer &"' and TABLE2.customerid = '"& id &"' and TABLE3.productname = '"& productname&"' "
...but not sure how to add the value "azdate". AZDATE is properly formatted, just can't figure how to insert it.
Code works ok but can't seem to add the date!
Thanks for your help.