...
| Variable | Placeholder Functionality |
|---|---|
%day% | Current day of month (01-31) |
| %hour% | Current hour (00-23) |
%id% | Auto increment number * |
| %min% | Current minute (00-59) |
| %sec% | Current second (00-59) |
| %ms% | Current minute (000-999) |
| %month% | Current month (01-12) |
| %sheet% | Sheet name |
| %user% | Current user |
| %wb% | Workbook name |
| %year% | Current year |
%partition% | Date partition(s) according to the configured filter, applicable to the path name only for partitioned export sheets |
...
Date and Time Pattern | Result |
|---|---|
"yyyy.MM.dd G 'at' HH:mm:ss z" | 2001.07.04 AD at 12:08:56 PDT |
"EEE, MMM d, ''yy" | Wed, Jul 4, '01 |
"h:mm a" | 12:08 PM |
"hh 'o''clock' a, zzz" | 12 o'clock PM, Pacific Daylight Time |
"K:mm a, z" | 0:08 PM, PDT |
"yyyyy.MMMMM.dd GGG hh:mm aaa" | 02001.July.04 AD 12:08 PM |
"EEE, d MMM yyyy HH:mm:ss Z" | Wed, 4 Jul 2001 12:08:56 -0700 |
"yyMMddHHmmssZ" | 010704120856-0700 |
| yyyy-MM-dd HH:mm:ss.SSSSSSSSS | 2012-05-16 11:16:55.532875532 |
When no patterns are used in file names, existing files are replaced.
...