Export batch script | Capture Current Date & time append with file name

xrprasadx

@Misbah

Hi Flok,

How to modified export script to get the customize file name along with current date & time

Regards,

Rahul

Accepted answers

xrprasadx

Thanks but below is the working script

============================

set hour=%time:~0,2%
if "%hour:~0,1%" == " " set hour=0%hour:~1,1%
set min=%time:~3,2%
if "%min:~0,1%" == " " set min=0%min:~1,1%
set sec=%time:~6,2%
if "%sec:~0,1%" == " " set secs=0%secs:~1,1%
set filename=D:\outfile_%date:~10,4%%date:~7,2%%date:~4,2%_%hour%%min%%sec%.csv%
set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "ExportName" -execute -get %filename%

======================================================================================================

All comments

abhay.kanik

@xrprasadx

Generally, the solution is quite simple — we should use the %date% and %time% built-in variables, that display date and time based on the regional coding.

for date
echo %date%
for time
echo %time%

just add in front of output file name in connect script for example - "\path\outfile_%date%%time%"

Hope it Helps!

xrprasadx

Thanks but below is the working script

============================

======================================================================================================

Quick Links

Can you help?

Unanswered questions

How do I determine why Anaplan API login fails intermittently ?
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Anaplan XL license issue
Hello , I recently started Anaplan XL course , added XL however not able to add license How to ad license
Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.