Hi, I'm hoping there is a simple answer to this question. I have a scheduled script running nightly that imports records from a file.
The filenames are standardized with "Import" then date: Import_20161008
Current script step for the filepath is:
Set Variable [ $filePath ; Value:"filewin:" & $LandingZone & $region & "Import_" & Year ( Get(CurrentDate) ) & Right ( "00" & Month ( Get ( CurrentDate ) ) ; 2 ) & Right("00" & Day ( Get ( CurrentDate ) ) ; 2) & ".csv"
The new filenames are going to include a timestamp, rather than just the date: Import_20161008_1463.csv
My question is: )other than manually removing the 4 numbers that represent the time) how do I account for the (dynamic) time in the filepath?