Highlighted
Occasional Contributor

Current system day or To Date

Hi Guys,

 

Can anyone please guide, if we have any syntax for retriving todays date i,e sysdate in Anaplan.

I have created a property with Date formatted,I want to view todays date in this line item.

 

Thanks

Madhabika

2 REPLIES 2
Highlighted
New Contributor

Re: Current system day or To Date

Hello Madhabika,

 

 

@echo on
:: This script looks up the current date, writes it to a csv file, and sends it to Anaplan 

:: Here we set the file path of the csv file we will be writing the current date too
set FileName="\\d-sapfiles\Interfaces\D_ANAPLAN\VOLFCST\OUT\CurrentDate.csv"

:: rem This is a simple for loop that parses the date /t function
FOR /f "tokens=1-4 delims=/ " %%a in ('date /t') do (set mm=%%a& set dd=%%b& set yyyy=% %c& (if "%%a:~0,1" gtr "9" set mm=%%b& set dd=%%c& set yyyy=%%d))

echo Todays date in Windows format is: %date%

set mydate=%yyyy%-%mm%-%dd%
echo 'Current Date': %mydate%

rem The following is not needed unless you have specific requirements to strip characters, etc
:: rem Remove leading Zeros from Day
:: set d=%dd%
:: set /a d=100%d% %% 100
:: rem Remove leading Zeros from Month
:: set m=%mm%
:: set /a m=100%m% %% 100
:: set snapshot=%d%-%m%-%yyyy%

set snapshot=%mydate%
echo 'Latest Snapshot': %snapshot%

@echo "Current Date","Latest Snapshot"> %FileName%
@echo "%mydate%","%snapshot%">> %FileName%

rem **************************************************************

set AnaplanUser=“XXX@anaplan.com"
set WorkspaceId=“XXX”
set ModelId=“XXX”
::  This variable AC_exe should be set to the path of the AnaplanClient.bat 
set AC_exe=D:\Anaplan\AnaplanClient.bat
::  This variable Cert should be set to the path of your Anaplan User's Certificate (can be downloaded from Anaplan under user profile on the top right)
set Cert="D:\Anaplan\certificate-XXXX.cer"
::  This variable LogPath should be set to the path of a folder/directory for the Anaplan Connect log files
set LogPath="D:\Anaplan\logs"

set Operation=-certificate %Cert% -file "CurrentDate.csv NOTE: This is the filename in the Anaplan Model when you click on Import Data Sources button" -put %FileName% -import "Import Current Date NOTE: This is the name of the Import Action in the Anaplan Model" -execute -output %LogPath% 

rem *** End of settings - Do not edit below this line ***

setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=%AC_exe% %Credentials% -s %ServiceLocation% -workspace %WorkspaceId% -model %ModelId% %Operation%
@echo %Command%
cmd /c %Command%
pause

save it with .bat extension and you can use it.

 

The actual code was in the other post.

I've made it available here. Thank you!

Highlighted
Occasional Contributor

Re: Current system day or To Date

I can't get this code to update my module:

 

@echo on
:: This script looks up the current date, writes it to a csv file, and sends it to Anaplan

:: Here we set the file path of the csv file we will be writing the current date too
set FileName="C:\Users\tobrien\Desktop\HDCCO\Scripts\Current Date.txt"

:: rem This is a simple for loop that parses the date /t function
FOR /f "tokens=1-4 delims=/ " %%a in ('date /t') do (set mm=%%a& set dd=%%b& set yyyy=% %c& (if "%%a:~0,1" gtr "9" set mm=%%b& set dd=%%c& set yyyy=%%d))

echo Todays date in Windows format is: %date%

set mydate=%yyyy%-%mm%-%dd%
echo 'Current Date': %mydate%

rem The following is not needed unless you have specific requirements to strip characters, etc
:: rem Remove leading Zeros from Day
:: set d=%dd%
:: set /a d=100%d% %% 100
:: rem Remove leading Zeros from Month
:: set m=%mm%
:: set /a m=100%m% %% 100
:: set snapshot=%d%-%m%-%yyyy%

set snapshot=%mydate%
echo 'Latest Snapshot': %snapshot%

@echo "Current Date"> %FileName%
@echo "%mydate%">> %FileName%

rem **************************************************************

set AnaplanUser=“tobrien@allitix.com"
set WorkspaceId=“8a81b09b652b035001653afaa0584473”
set ModelId=“61E67CEB032C4CD4BA1E1E489D1A16E4”
:: This variable AC_exe should be set to the path of the AnaplanClient.bat
set AC_exe=C:\Users\tobrien\Desktop\HDCCO\Batch\AnaplanClient.bat
:: This variable Cert should be set to the path of your Anaplan User's Certificate (can be downloaded from Anaplan under user profile on the top right)
set Cert="C:\Users\tobrien\Desktop\HDCCO\Cert"
:: This variable LogPath should be set to the path of a folder/directory for the Anaplan Connect log files
set LogPath="C:\Users\tobrien\Desktop\HDCCO"

set Operation=-certificate %Cert% -file "Current Date.txt NOTE: This is the filename in the Anaplan Model when you click on Import Data Sources button" -put %FileName% -import "Import Current Date NOTE: This is the name of the Import Action in the Anaplan Model" -execute -output %LogPath%

rem *** End of settings - Do not edit below this line ***

setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=%AC_exe% %Credentials% -s %ServiceLocation% -workspace %WorkspaceId% -model %ModelId% %Operation%
@echo %Command%
cmd /c %Command%
pause