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 Continue reading