Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Date 'shortcuts'

Many of the grid queries 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.

YeaR (Calendar)

Y - Jan 1 of current calendar year

R - Dec 31 of current calendar year

FiscaL

F - July 1 of current fiscal year

L - June 30 of current fiscal year

MontH (based on current system date)

M - first of current month

H - last day of current month

WeeK

W - Sunday

K - Saturday

PerioD (Posting Period)

P - first day of current posting period

D - last day of current posting period

Quarter

Q - first day of quarter

U - last day of quarter

T - today

+ tomorrow

- yesterday

  • No labels