


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.
Solved! Go to Solution.
Views
Replies
Sign in to like this content
Total Likes
Views
Replies
Sign in to like this content
Total Likes
Hi,
Try <%= formatDate(new Date(), "%4Y%2M%2D") %>.txt
Thanks,
David
Views
Replies
Sign in to like this content
Total Likes
David - I continue to get an error. XTK-170037 '%' is a binary operator. At least one operand is missing
Views
Replies
Sign in to like this content
Total Likes
Try this
Year(GetDate())+''+ Iif(Month(GetDate())>9, Month(GetDate()), '0'+Month(GetDate())) +''+Day(GetDate())
or
Substring(ToString(GetDate()),1, 4)+''+Substring(ToString(GetDate()),5, 2)+''+Substring(ToString(GetDate()),7, 2)
the number in red is ajustable regarding what your ToString(GetDate()) return
Thanks,
David
Views
Replies
Sign in to like this content
Total Likes
Views
Replies
Sign in to like this content
Total Likes