Date/Time Fields for Output File/Folder

Output file/folder names can have date and time attributes associated with it. The following fields are recognized:

Field

Meaning

[YMD] Date in the format YYYYMMDD (year, month, day)
[MDY] Date in the format MMDDYYYY (day, month, year)
[Y] Year in the format YYYY
[M] Month in the format MM
[D] Day in the format DD
[HIS] Time in the format hhmmss (hour, minute, second)
[H] Hour in the format hh
[I] Minute in the format mm
[S] Second in the format ss


Example 1:

   Date: December 16th, 2015.

   Input file = abcd.txt

   Output file = C:\foldername\abcd-[M]-[D]-[Y].xls

   The output file created: C:\foldername\abcd-12-16-2015.xls

Example 2:

   Date: April 3rd, 2016.

   Input file = abcd.txt

   Output file = C:\foldername-[YMD]\abcd-[M]-[D]-[Y].xls

   The output file created: C:\foldername-20160403\abcd-12-16-2015.xls