Date Shortcuts
Date 'Shortcuts'
Many of the grid queries, entry screens and reports allow for a date or date range to be entered. For example, you can use the beginning and ending characters to indicate the beginning and ending dates for the current applicable period. Please note these aren't case-sensitive:
Examples: The following are the list of letters/symbols used and its meaning(letters are NOT case sensitive):
Today's date is 4/18/18
YeaR (Calendar)
Y - January 1st of current year 1/1/18
R - December 31 of current year 12/31/18
FiscaL
F - 1st day of current fiscal start date 7/1/17
L - Last day of current fiscal end date 6/30/18
MontH (based on current system date)
M - 1st day of current month 4/1/18
H - Last day of current month 4/30/18
WeeK
W - 15th day of current month 4/15/18
K - Saturday of current week 4/21/18
PerioD (Posting Period)
P - 1st day of next month 5/1/18
D - Last day of next month 5/31/18
Quarter
Q - 1st day of current quarter 4/1/18
U - Current date 4/18/18
Quarter
Q - 1st day of the current quarter 04/01/2018
R - Last day of the current quarter 06/30/2018
Posting Period
p (beginning of posting period)
t (today)
T - today
+ Tomorrow's date 4/19/18
- Yesterday's date 4/17/18