Format Date - ACS - need YYYYMMDD | Community
Skip to main content
H
holmes74338504
Level 3
August 25, 2020
Solved

Format Date - ACS - need YYYYMMDD

  • August 25, 2020
  • 1 reply
  • 3545 views

Hello, 

 

I create an automation where a Scheduler attached to an END activity, that has 3 variables I've identified, and would kick off an External Signal in another workflow.  

 

The External signal goes right into a Transfer File activity and here's where I need help. The Transfer File will download a file located in an external SFTP. The filename contains a date field in it. 

 

I tried the following - $(vars/@FilePath)+$(vars/@FileMask)+Year(GetDate())+Month(GetDate())+Day(GetDate())+'.'+$(vars/@File_Extension) - but it returns this: 

 

outgoing/batch_push/2_167_USER_PROFILE_2020825.zip 

 

When I need it return this: outgoing/batch_push/2_167_USER_PROFILE_20200825.zip'

 

Can someone guide me on how to get this to be a 2 digit month. I tried LPad and some other coding and they failed. This isn't an issue for me in ACC since I can use a script, but I'm have a hard time in ACS. 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DavidKangni

Hi,

 

Try <%= formatDate(new Date(), "%4Y%2M%2D") %>.txt

 

Thanks,

David

 

1 reply

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
August 25, 2020

Hi,

 

Try <%= formatDate(new Date(), "%4Y%2M%2D") %>.txt

 

Thanks,

David

 

David Kangni
H
holmes74338504Author
Level 3
August 28, 2020
David, your latest comment worked!!
Terms & ConditionsAccessibility statement

Loading footer...