| The "Date" column of the main window can be customized to display the date/time with a custom-selected date format.
Showing Dates:
Year |
Month |
Day |
| y |
2 digit year |
13 |
m |
no leading zero |
1 |
d |
Day number (no leading zero) |
7 |
| yy |
2 digit year |
13 |
mm |
2 digit month |
01 |
dd |
2 digit day |
07 |
| yyyy |
4 digit year |
2013 |
mmm |
Short Name |
Jan |
ddd |
Day of Week (Short) |
Sun |
| |
mmmm |
Long Name |
January |
dddd |
Day of Week (Long) |
Sunday |
Slash (/) will be replaced by regional date seperator. If you wish to use a different seperator, enclose the deisred seperator in single or double quotes.
Additionally, there are shortcuts for specific date formats specified in the Windows Regional Settings:
Date Format Shortcuts |
| ddddd |
Short Date Format |
7/10/2013 |
| dddddd |
Long Date Format |
Wednesday, July 10, 2013 |
Showing Times:
| |
Hour |
Minute |
Seconds |
Milliseconds |
| No Leading Zero |
h |
n |
s |
z |
| Show Leading Zero |
hh |
nn |
ss |
zzz |
Colon (:) will be replaced with the regional time seperator. If you wish to use a different seperator, enclose it in single or double quotes.
If you prefer 12 hour AM/PM time to 24 hour time, add one of these after your time format string:
| Time Format |
Result (for Region US/English) |
| AM/PM |
AM or PM |
| am/pm |
am or pm |
| A/P |
A or P |
| a/p |
a or p |
| ampm |
regional AM or PM string (may be blank in some regions) |
Times also have shortcut formats for the regional long or short time formats:
Time Format Shortcuts |
| t |
Short Time Format |
4:23 PM |
| tt |
Long Time Format |
4:47:40 PM |
| c |
Short Date Format + Long Time Format |
7/10/2013 4:23:58 PM |
Here are some examples of different ways to display the date and time:
Date/Time Format Examples |
Format |
Region: English (US) |
Region: German (Germany) |
| m/d h:mma/p |
7/10 4:23p |
7.10 4:23p |
| m/d/yy h:mAM/PM |
7/10/13 4:23PM |
7.10.13 4:23PM |
| mmm-d h:mampm |
Jul-10 4:23PM |
Jul-10 4:23 |
| mmm-d h:mm |
Jul-10 16:23 |
Jul-10 16:23 |
| c |
7/10/2013 4:23:58 PM |
10.07.2013 16:23:58 |
| ddd m-dd t |
Wed 7-10 4:23 PM |
Mi 7-10 16:23 |
| h:m' on 'mmm/dd |
16:23 on Jul/10 |
16:23 on Jul.10 |
|