I don't know if its too late to answer or not . here is the way to get date .

CREATE TABLE #mytable ( Line VARCHAR(512))

SET @PathName = '\\uncpath\foldername\flodername\foldername\' ...