A date or time pattern letter represents a date or time component, such as the day of week or hour of the day.
If you want to include normal words in some text that accepts date and time pattern letters, you must surround that text with single quotes, and the entirety of the text with double quotes.
The example above will name the file
Note that the name ends with
.zip, this is to keep the file extension correct.
The format name is always in double quotes
"", to specify a name, you put it in single quotes
'name' and to specify a date format you put it without the single quotes or outside of single quotes.
|Letter||Date or Time Component||Output Examples||Use Examples|
|y||Year||1996; 96||YYYY; YY|
|M||Month in a year||July; Jul; 07||MMMM; MMM; MM|
|w||Week in a year||27||w|
|W||Week in a month||2||W|
|d||Day in a month||10||d|
|D||Day in a year||189||D|
|F||Day of week in month||2||F|
|E||Day in week||Monday: M||E; EEEEE|
|h||Hour in Am/Pm (1-12)||12||h|
|H||Hour in day (0-23)||0||H|
|m||Minute in hour||30||m|
|s||Second in minute||55||s|