rem Setting the Start Date & Time that the batch was launched
===============================================================
set yyyy=%date:~10,4%
set mm=%date:~4,2%
set dd=%date:~7,2%
set hh=%time:~0,2%
set mn=%time:~3,2%
set ss=%time:~6,2%

set yyyy=%date:~10,4%
set mm=%date:~4,2%
set dd=%date:~7,2%
for /f "tokens=1-2 delims=: " %%a in ('time /t') do (set hh=%%a& set mn=%%b)
set ss=%time:~6,2%
set dstamp="%yyyy%"-"%mm%"-"%dd%"_"%hh%%mn%%ss%"
set dstamp2="%yyyy%"."%mm%"."%dd%"
set dstamp3 = dstamp2 - 6 days                  REM<---------------------------------------------------------this is the parameter i need changed
===============================================================

ren  "TRD_Cost.PSV"  "TRD_Cost_%dstamp3%_%dstamp2%.PSV"     REM<----------------------------------------------------renamed here
rem zip -j %exepath%\..\HostTran\Export\Dunnhumby\TRD_Cost_%dstamp2%.PSV.zip  %exepath%\..\HostTran\Export\Dunnhumby\TRD_Cost*.PSV >> %log%
rem move %exepath%\..\HostTran\Export\Dunnhumby\TRD_Cost_%dstamp2%.PSV.zip   %exepath%\..\HostTran\Export\Dunnhumby\backup\ >> %log%
rem del %exepath%\..\HostTran\Export\Dunnhumby\TRD_Cost*.PSV >> %log%

REM so this is what i want to rename the file: TRD_Cost_dstamp3 _dstamp2.psv where dstamp3 = 

Select all Open in new window

[b]@echo off
setlocal

:: *** csv-File with the name, first name, and user name:
set UserFile=\\Srv_\publico\DATOS\Procedimiento\Procedimientos\prorrogarUsuario\prorroga.csv

:: *** Distinguished Name of the container to add the new user to:
set UsersDN=OU=Usuarios,OU=UsuariosCM,OU=CM,DC=D,DC=domain,DC=com

for /f "tokens=1-4 delims=," %%a in ('type "%UserFile%"') do (
  set Userp=%%a
  set Date=%%b
  call :process
)
goto :leave

:process
set USER=%Userp%

echo Prorrogando usuario
echo Username: %USER% date: %Date%

echo.
:: ***echo Hit ^<ctrl-c^> to stop, any other key to create the user.
:: ***pause >NUL
echo.

:: *** Test mode: Remove the "ECHO" in front of the following line to run the script for real:
net user %USER% /expires:%Date% /DOMAIN

:leave[/b]

Select all Open in new window

SET NOCOUNT ON;

IF OBJECT_ID('tempdb..#files') IS NOT NULL
DROP TABLE #files;
CREATE TABLE #files (Line VARCHAR(512)) 
DECLARE @path VARCHAR(49) 
DECLARE @cmd1 VARCHAR(155)
DECLARE @cmd2 VARCHAR(155)
DECLARE @filename VARCHAR(255)
SET @path = 'dir \\backups\servername\dbname\FULL\'
SET @cmd1 =  @Path+' /A-D  /B' 
--PRINT @cmd1

INSERT #files
EXEC master..xp_cmdshell @cmd1
DELETE #files WHERE Line IS NULL
--SELECT * FROM #files

SET @filename = (SELECT Line FROM #files)
SET @cmd2 = 'del \\backups\servername\dbname\FULL\' + @FileName
--PRINT @cmd2

IF EXISTS(SELECT

Select all Open in new window