Task Scheduler sqlcmd with %date command no output and no error log

Dear all, 
I am a newbie, and i hope i got the right forum for sqlcmd in task scheduler. We are using Server 2008, SQL Server 2008 Express, and are using Windows Task Scheduler for scheduling an Excel output for research purposes. The following string works in command prompt with csv created, but no csv file when scheduled as an action in Task Scheduler.  
sqlcmd -i " ...