Current system day or To Date

Madhabika
Madhabika
in Academy and learning discussions

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

Comments

  • missmansirao
    missmansirao

    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 **** 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=“[email protected]"
    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!

  • tobrien
    tobrien

    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 **** 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=“[email protected]"
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

Categories