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.

Days

Calendar months

Work* Days

Start of Month

End of Month

Start of Work* Month

End of Work* Month

Start of Quarter

End of Quarter

Start of Work* Quarter

End of Work* Quarter

Start of Period

End of Period

Start of Work* in a Period

End of Work* in a Period

Start of Year

End of Year

Start of Work* Year

End of Work* Year

* "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