Use this function to create a variety of Date and Time formats. It provides plenty of flexibility in displaying dates and/or times. Many of these formats are based on what are defined in the Regional Settings of the Windows Control Panel. The month, day, etc. will display in the language defined in the Regional Settings.
Keyboard Express - Editor > Date/Time
Choose a Date or Time Format
Several sample formats may be selected from the drop down menu. Or create a custom format for date, time or both. All of the available format options are listed at the bottom of this topic. Just type the characters into the format field that correspond with the results needed.
Date/Time
Use Current Date / Time
This option displays the date and time from the system clock at the time the macro runs.
Specific Date / Time
Use this option to display a specific date or time during macro playback. Set the value to a specific date or time, either in the past or future.
Adjust Current Date/ Time
Adjust the date or time by Days, Months, Years, Hours, Minutes or Seconds into the future or past. The calculations are based on the computer's current system time and date. Insert negative numbers in the fields to adjust the date or time to the past.
List of Format Options
|
Modifier |
Description |
|
c |
Displays the date using the Short Date Format defined in the Control Panel - Regional Settings, followed by the time using the Long Time format defined in the Control Panel - Regional Settings. The time is not displayed if the fractional part of the Date Time value is zero. |
|
d |
Displays the day as a number without a leading zero (1-31). |
|
dd |
Displays the day as a number with a leading zero (01-31). |
|
ddd |
Displays the day as an abbreviation (Sun-Sat) using the Short Day Name format defined in the Control Panel - Regional Settings. |
|
dddd |
Displays the day as a full name (Sunday-Saturday) using the Long Day Name format defined in the Control Panel - Regional Settings. |
|
ddddd |
Displays the date using the Short Date format defined in the Control Panel - Regional Settings. |
|
dddddd |
Displays the date using the Long Date format defined in the Control Panel - Regional Settings. |
|
m |
Displays the month as a number without a leading zero (1-12). If the m specifier immediately follows an h or hh specifier, the minute rather than the month is displayed. |
|
mm |
Displays the month as a number with a leading zero (01-12). If the mm specifier immediately follows an h or hh specifier, the minute rather than the month is displayed. |
|
mmm |
Displays the month as an abbreviation (Jan-Dec) using the Short Month Names format defined in the Control Panel - Regional Settings. |
|
mmmm |
Displays the month as a full name (January-December) using the Long Month Names format defined in the Control Panel - Regional Settings. |
|
yy |
Displays the year as a two-digit number (00-99). |
|
yyyy |
Displays the year as a four-digit number (0000-9999). |
|
h |
Displays the hour without a leading zero (0-23). |
|
hh |
Displays the hour with a leading zero (00-23). |
|
n |
Displays the minute without a leading zero (0-59). |
|
nn |
Displays the minute with a leading zero (00-59). |
|
s |
Displays the second without a leading zero (0-59). |
|
ss |
Displays the second with a leading zero (00-59). |
|
z |
Displays the millisecond without a leading zero (0-999). |
|
zzz |
Displays the millisecond with a leading zero (000-999). |
|
t |
Displays the time using the Short Time format defined in the Control Panel - Regional Settings. |
|
tt |
Displays the time using the Long Time format defined in the Control Panel - Regional Settings. |
|
am/pm |
Uses the 12-hour clock for the preceding h or hh specifier, and displays 'am' for any hour before noon, and 'pm' for any hour after noon. The am/pm specifier can use lower, upper, or mixed case, and the result is displayed accordingly. |
|
a/p |
Uses the 12-hour clock for the preceding h or hh specifier, and displays 'a' for any hour before noon, and 'p' for any hour after noon. The a/p specifier can use lower, upper, or mixed case, and the result is displayed accordingly. |
|
ampm |
Uses the 12-hour clock for the preceding h or hh specifier, and displays AM symbol defined in the Control Panel - Regional Settings for any hour before noon, and the contents of the PM setting defined in the Control Panel - Regional Settings for any hour after noon. |
|
/ |
Displays the date separator character defined in the Control Panel - Regional Settings. |
|
: |
Displays the time separator character defined in the Control Panel - Regional Settings. |
|
'xx'/"xx" |
Characters enclosed in single or double quotes are displayed as-is, and do not affect formatting. |