Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

AutoPilot Command Line Substitutions


The input and output directories can contain date and time tags that will be replaced with current date and time elements. The following tags are available.

Tag Result
%YEAR% Current year, four digits
%MONTH% Current month, two digits
%DAY% Current day of the month, two digits
%HOUR% Current hour, 2 digits, 24 hour clock
%MINUTE% Current minute, 2 digits
If you are using the command line substitutions listed above in a batch file, you will have to use %% instead of % on either side of the tag. The %% is necessary because %NAME% in a batch file is also used for substitution.

The date and time substitutions are based on the date and time that AutoPilot starts.

For example:

AutoPilot /M VALUES /I "C:\JetReports\MyFile.xlsx" /O "C:\JetReports\Output\%Year%-%Month%-%Day% %Hour%"

If the AutoPilot started at 10PM on July 23, 2019 the output directory from the above command line would be C:\JetReports\Output\2019-07-23 10.xlsx.

Was this article helpful?
0 out of 0 found this helpful