Date Shortcuts
The advantage of entering a date shortcut is that the program replaces the shortcut with the appropriate current date. For example, if you enter T for today for a report selection option, the program always uses today's date. Likewise, if you enter EOM or EOP for reports that you run at the end of the month or period, you won't have change the date for selection or program options each time you run the report.
* "work" date shortcuts are based on your shop calendar
The Result column below assumes that your date format is mm/dd/yy, that today is April 15, that your fiscal quarter begins March 1, and your fiscal year begins on June 1.
Days
For |
Enter |
Example |
Result |
Today |
T |
T |
04/15/yy |
System date |
S |
S |
04/15/yy |
Tomorrow |
TM |
TM |
04/16/yy |
n days after today |
+n |
+2 |
04/17/yy |
Yesterday |
Y |
Y |
04/14/yy |
n days before today |
-n |
-2 |
04/13/yy |
Calendar Months
For |
Enter |
Example |
Result |
n months after today |
+nM |
+2M |
06/15/yy |
n months before today |
-nM |
-2M |
02/15/yy |
Start of Month
For |
Enter |
Example |
Result |
Start of the calendar month |
SOM |
SOM |
04/01/yy |
Start of calendar month n months in the future |
+nSOM |
+2SOM |
06/01/yy |
Start of calendar month n months in the past |
-nSOM |
-1SOM |
03/01/yy |
End of Month
For |
Enter |
Example |
Result |
End of the calendar month |
EOM |
EOM |
04/30/yy |
End of calendar month n months in the future |
+nEOM |
+2EOM |
06/30/yy |
End of calendar month n months in the past |
-nEOM |
-1EOM |
03/31/yy |
Start of Quarter
For |
Enter |
Example |
Result |
Start of the calendar quarter |
SOQ |
SOQ |
04/01/yy |
Start of the fiscal quarter |
SOFQ |
SOFQ |
03/01/yy |
End of Quarter
For |
Enter |
Example |
Result |
End of the calendar quarter |
EOQ |
EOQ |
06/30/yy |
End of the fiscal quarter |
EOFQ |
EOFQ |
05/31/yy |
Start of Period
For |
Enter |
Example |
Result |
Start of the fiscal period |
SOP |
SOP |
04/01/yy |
Start of the fiscal period n periods in the future |
+nSOP |
+3SOP |
07/01/yy |
Start of the fiscal period n periods in the past |
-nSOP |
-1SOP |
03/01/yy |
End of Period
For |
Enter |
Example |
Result |
End of the fiscal period |
EOP |
EOP |
04/30/yy |
End of the fiscal period n periods in the future |
+nEOP |
+3EOP |
07/31/yy |
End of the fiscal period n periods in the past |
-nEOP |
-1EOP |
03/31/yy |
Start of Year
For |
Enter |
Example |
Result |
Start of the calendar year |
SOY |
SOY |
01/01/yy |
Start of the fiscal year |
SOFY |
SOFY |
06/01/yy |
End of Year
For |
Enter |
Example |
Result |
End of the calendar year |
EOY |
EOY |
12/31/yy |
End of the fiscal year |
EOFY |
EOFY |
05/31/yy |
"Work" date shortcuts are based on your shop calendar. Because shop calendars vary greatly, no results column is included in the examples below.
Work Days
For |
Enter |
Example |
n work days after today |
+nW |
+2W |
n work days before today |
-nW |
-2W |
The next work day n months after today |
+nWM |
+2WM |
Last work day n months before today |
-nWM |
-2WM |
Start of Work Month
For |
Enter |
Example |
First work day of month |
WSOM |
WSOM |
First work day of the month n months in the future |
+nWSOM |
+2WSOM |
First work day of the month n months in the past |
-nWSOM |
-1WSOM |
End of Work Month
For |
Enter |
Example |
Last work day of month |
WEOM |
WEOM |
Last work day of the month n months in the future |
+nWEOM |
+2WEOM |
Last work day of the month n months in the past |
-nWEOM |
-1WEOM |
Start of Work Quarter
For |
Enter |
Example |
First work day of the calendar quarter |
WSOQ |
WSOQ |
First work day of the fiscal quarter |
WSOFQ |
WSOFQ |
End of Work Quarter
For |
Enter |
Example |
Last work day of the calendar quarter |
WEOQ |
WEOQ |
Last work day of the fiscal quarter |
WEOFQ |
WEOFQ |
Start of Work in a Period
For |
Enter |
Example |
First work day of the fiscal period |
WSOP |
WSOP |
First work day in the period n periods in the future |
+nWSOP |
+3WSOP |
First work day in the period n periods in the past |
-nWSOP |
-1WSOP |
End of Work Period
For |
Enter |
Example |
Last work day of the fiscal period |
WEOP |
WEOP |
Last work day of the period n periods in the future |
+nWEOP |
+3WEOP |
Last work day of the period n periods in the past |
-nWEOP |
-1WEOP |
Start of Work Year
For |
Enter |
Example |
First work day of the year |
WSOY |
WSOY |
First work day of the fiscal year |
WSOFY |
WSOFY |
End of Work Year
For |
Enter |
Example |
Last work day of the year |
WEOY |
WEOY |
Last work day of the fiscal year |
WEOFY |
WEOFY |