The list of date formats within SmartConnect can be managed via the Date Formats window. This window is accessed via the Date Column settings window.
To add a new date format:
| 1. | Open the date formats window via the date column settings window by clicking Manage Formats. |
| 2. | Enter a name for the new format, names must be unique. Select Add to add the new format name to the grid. |
| 3. | Add the new format to the new format name in the grid. |
| 4. | Any format other than system formats can be edited or removed within this screen. |
Standard date format strings:
Format |
Description |
Example |
d |
The day of the month 1 - 31 |
6 July 2010 1:45:30 PM » 6 15 July 2010 1:45:30 PM » 15 |
dd |
The day of the month 01 – 31 |
6 July 2010 1:45:30 PM » 06 15 July 2010 1:45:30 PM » 15 |
ddd |
The abbreviated day of the week |
6 July 2010 1:45:30 PM » Tue |
dddd |
The full name of the day of the week |
6 July 2010 1:45:30 PM » Tuesday |
h |
The hour using a 12 hour clock from 1 – 12 |
6 July 2010 1:45:30 PM » 1 |
hh |
The hour using a 12 hour clock from 01 – 12 |
6 July 2010 1:45:30 PM » 01 |
H |
The hour using a 24 hour clock from 1 – 24 |
6 July 2010 1:45:30 PM » 13 |
HH |
The hour using a 24 hour clock from 01 – 24 |
6 July 2010 1:45:30 PM » 13 |
K |
Time zone information |
6 July 2010 1:45:30 PM +10:00 » +10:00 |
m |
The minute from 0 – 59 |
6 July 2010 1:09:30 PM » 9 |
mm |
The minute from 00 – 59 |
6 July 2010 1:09:30 PM » 09 |
M |
The month from 1 – 12 |
6 July 2010 1:45:30 PM » 7 |
MM |
The month from 01 -12 |
6 July 2010 1:45:30 PM » 07 |
MMM |
The month name abbreviated |
6 July 2010 1:45:30 PM » Jul |
MMMM |
The full month name |
6 July 2010 1:45:30 PM » July |
s |
The second from 0 – 59 |
6 July 2010 1:45:03 PM » 3 |
ss |
The second from 00 – 59 |
6 July 2010 1:45:03 PM » 03 |
t |
The first character of AM/PM |
6 July 2010 1:45:03 PM » P |
tt |
The AM/PM designator |
6 July 2010 1:45:03 PM » PM |
y |
The year from 0 – 99 |
6 July 2009 1:45:03 PM » 10 |
yy |
The year from 00 – 99 |
6 July 2009 1:45:03 PM » 09 |
yyyy |
The year as a 4 digit number |
6 July 2009 1:45:03 PM » 2009 |
: |
Time separator |
|
/ |
Date separator |
|
Any other character |
The character is copied to the result string unchanged. |
|
For more information see http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx