Table of Contents
Date Select Fields
Date Select Fields appear on numerous reports and processes in RecTrac. As shown in the example below, they consist of two (2) fields, the Date Select Option field (the Drop-down list on the left) and the Entry field (on the right), which work together and allow you to specifiy an exact date.
The following table presents selection definitions and examples for the Date Select Fields in RecTrac.
Note: Begin of Year and End of Year options evaluate to the Calendar Year and use 01 January and 31 December respectively, in the event your Fiscal Year is different from the Calendar Year.
Date Select Option | Input Type | Entry | Examples |
---|---|---|---|
Actual Date | Date | Select a Static Date | 07/01/1985 04/20/2017 12/31/2999 etc… |
Today | Integer +/- | Uses "Today's" Date +/- the Integer | 0 = "Today" 1 = "Tomorrow" 2 = "Day after tomorrow" 14 = "14 days/two weeks from today" -1 = "Yesterday" -4 = "Four days ago" -30 = "30 Days ago" etc… |
Begin of Month | Integer +/- | Evaluates to 1st day of the Month | 0 = "1st day of this Month" 1 = "1st day of next month" 2 = "1st day of the month after next" 6 = "1st day of the month, six months from now" -1 = "1st day of last month" -4 = "1st day of four months ago" etc… Note: Do not enter an integer as if it were a Month. For Example: Entering '6' in reference to the 6thmonth of the year (June) would actually evaluate to the first of the month six months from "today." If "today" were April 09, six months from "today" would be October. |
End of Month | Integer +/- | Evaluates to the last day of the Month | 0 = "Last day of this Month" 1 = "Last day of next month" 2 = "Last day of the month after next" 6 = "Last day of the month, 6 months from now" -1 = "Last day of last month" -4 = "Last day of four months ago" etc… Note: Do not enter an integer as if it were a Month. For Example: Entering '6' in reference to the 6thmonth of the year (June) would actually evaluate to the first of the month six months ago as of "today." If "today" were April 09, six months ago from "today" would be September. |
Begin of Year | Integer +/- | Evaluates to 01 January of the Year | 0 = "01 January this Year" 1 = "01 January next year" 2 = "01 January the year after next" 6 = "01 January, six years from now" -1 = "01 January last year" -4 = "01 January of four years ago" etc… Note: Do not enter an integer as if it were a Year. For Example: Entering '2017' in reference to the year 2017 would actually evaluate to the first day of the year 2,017 years from now. |
End of Year | Integer +/- | Evaluates to 31 December of the Year | 0 = "31 December this Year" 1 = "31 December next year" 2 = "31 December the year after next" 6 = "31 December, 6 years from now" -1 = "31 December last year" -4 = "31 December of four years ago" etc… Note: Do not enter an integer as if it were a Year. For Example: Entering '2017' in reference to the year 2017 would actually evaluate to the last day of the year 2,017 years from now. |
Sunday - Saturday | Integer +/- | Evaluates to the Day of the Week selected | Each week day is its own option. Using "Sunday" as an example: 0 = "This Sunday" 1 = "Next Sunday" 2 = "Two Sundays from now" 6 = "Sunday, 6 weeks from now" -1 = "Last Sunday" -4 = "Four Sundays ago" etc… |
Day of This Month | Integer + | 1-31 Valid Day | 1 = "1st of this month" 15 = "15th of this month" 28 = "28th of this month" etc… |
Day of Last Month | Integer + | 1-31 Valid Day | 1 = "1st of last month" 15 = "15th of last month" 28 = "28th of last month" etc… |
Day of Next Month | Integer + | 1-31 Valid Day | 1 = "1st of next month" 15 = "15th of next month" 28 = "28th of next month" etc… |
Time Select Fields
Time Select Fields appear on numerous reports and processes in RecTrac. As shown in the example below, they consist of two (2) fields, the Time Select Option field (the Drop-down list on the left) and the Entry field (on the right), which work together and allow you to specifiy an exact time.
The following table presents selection definitions and examples for the Tme Select Fields in RecTrac.
Time Select Option | Input Type | Entry | Examples |
---|---|---|---|
Actual Time | Clock Time | Enter or Select a Time of Day | 9:00 10:30 11:45 etc… |
Current Time | Integer +/- | Uses the Current Time +/- the Integer | 0 = "Now" 1 = "One minute from Now" 10 = "Ten minutes from Now" -1 = "One minute ago" -30 = "30 minutes ago" etc… |
Combined Date/Time Range
Combined Date/Time Fields appear on GL Reports and Cash Journals only. As shown in the example below, they consist of four (4) fields, the Date Select Option field (the Drop-down list on the left), the Entry field (to its right), the Time Select Option field (the Drop-down list on the left) and the Entry field (its right) which work together and allow you to specifiy an exact date.
The Combined Date/Time option allows you to run a report continuously over your Date/Time range.
For Example: you select the date range 04/20/2020 - 04/24/2020 (Monday - Friday) and a time range of 06:00am - 02:00pm. If using the Combined Posting Date/Time Range, then the report will include all the transactions that took place starting at 06:00am on 04/22 and running through 02:00pm on 04/26.
The Date and Time fields work exactly as explained above; they are simply combined in this field.
If you have further questions regarding the steps outlined here, please contact Vermont Systems Support by phone at 887-883-8757 or generate a Support Ticket through the Customer portal of the Vermont Systems web site using your Customer ID and password.