Using sqlcmd to set file name

Credits: https://dba.stackexchange.com/questions/94774/how-to-use-sqlcmd-to-create-file-names-for-output-based-on-the-day-of-the-week-o

For date only can look at:

https://forums.asp.net/t/1616515.aspx?SQLCMD+timestamp+output+file