...it trucates at the first percent sign and yields a cron error:
unexpected EOF while looking for matching ``'
...cron executes:
/home/mylogin/tests/script.sh > /home/mylogin/tests/`date +"
Backticks mean you want your shell execute the command, but clearly shell is not there to do this when crontab job is executed. I would leave detailed explanation to someone more competent; but I can offer a workaround: Stick the redirection into your script:
$ cat /home/mylogin/tests/script.sh
#!/bin/bash
(
#whatever your script is doing
) > /home/mylogin/tests/`date +%Y%m%d`log.csv
This will run the body of the script in subshell and capture the output into the file
When I use cron I've found that it is almost always necessary to fully qualify executables. So you might try putting the path in front of the date command.
Also, you might try using single quotes in conjunction with your backticks.
You may find that just pathing the date command does it for you. (I'm not on my unix box right now and don't recall off the top of my head if date is in /bin)