Use dates in scheduled jobs export file name
Each time an export file is written by a scheduled job, the previous file is overwitten. If the previous file should be kept you can specify date and time to be included in the file path.
Step-by-step guide
- Edit the scheduled job which exports the file
- Change Path to Export File to include a date pattern (see below) surrounded by %, e.g. file%yyyyMMdd%.xls which will create the file "file20141231.xls" if today's date is Dec 31, 2014.
- Save job. Next export will now write a file including the date and/or time
Date pattern letters
| Letter | Date or Time Component | Presentation | Examples |
|---|---|---|---|
G | Era designator | Text | AD |
y | Year | Year | 1996; 96 |
M | Month in year | Month | July; Jul; 07 |
w | Week in year | Number | 27 |
W | Week in month | Number | 2 |
D | Day in year | Number | 189 |
d | Day in month | Number | 10 |
F | Day of week in month | Number | 2 |
E | Day in week | Text | Tuesday; Tue |
a | Am/pm marker | Text | PM |
H | Hour in day (0-23) | Number | 0 |
k | Hour in day (1-24) | Number | 24 |
K | Hour in am/pm (0-11) | Number | 0 |
h | Hour in am/pm (1-12) | Number | 12 |
m | Minute in hour | Number | 30 |
s | Second in minute | Number | 55 |
S | Millisecond | Number | 978 |
z | Time zone | General time zone | Pacific Standard Time; PST; GMT-08:00 |
Z | Time zone | RFC 822 time zone | -0800 |
Date patterns can also be used for folder names in the Export File path.
Related articles