Format a DOS date as yyyymmdd

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

tammylynnwoods Valued Member Points: 71 More actions · Answer 1

I couldn't get the osql command to work with the variable for the date.

Here's the osql cmd:

set var=%date%

osql.exe -U sa -P password -h-1 -s "," -n -i c:\paymentproductivityreport.sql -o c:\paymentproductivity_%var%.csv