I am trying to write a date into SQL in .afl using odbcExecuteSQL command. I cannot recall an easy way to do this unless I were to use string manipulation. Is there an easy way to complete the DATE-GOES-HERE part of my second insert command?
The following works great, except it doesn't include date:
odbcExecuteSQL("INSERT INTO trades (price,SYMBOL) VALUES( '"+C+"','"+Name()+"'
)");
I want
odbcExecuteSQL("INSERT INTO trades (DATE,price,SYMBOL) VALUES
(?DATE-GOES-HERE?? '"+C+"','"+Name()+"' )");
