Hello all, the error was you need to pass the date value enclosed in double quotes and set the date format to American, this works:

mydate = '"' + dtoc({07/27/05}) + '"'

thanks you all for your time