Calendar and dates

You can define default calendar and date options for each GainSeeker configuration, on the Configurations tab of the GainSeeker System Administration module.

 

Contents  [Hide]

 
 

Navigating to these settings

Navigate to the Calendar and dates settings on the Configurations tab of the System Administration module following this path:

Configurations | (configuration name) | Calendar and dates

Calendar format

This setting affects all of the predefined date periods that relate to weeks, months, quarters, and years.

Fiscal 4,4,5 and Fiscal 5,4,4

If your analysis and reporting must adhere strictly to a fiscal calendar used by your organization, you should choose the one of the Fiscal calendar formats:

Setting:

Explanation:

4, 4, 5

Each quarter in the fiscal year begins with a four-week month, followed by another four-week month and then a five-week month

5, 4, 4

Each quarter in the fiscal year begins with a five-week month, followed by a four-week month and then another four-week month

If you choose one of the Fiscal calendar formats, you should also set the Fiscal calendar options.

Gregorian calendar

Most GainSeeker users choose the Gregorian calendar. With this setting, pre-defined date periods are defined according to the following rules:

Date period:

Rule:

Current Week, Previous Week, etc.

The week begins on the First day of the week.

Current Month, Previous Month, January from Current year, etc.

The month begins on the first day of the calendar month (e.g., January 1, February 1, etc.).

Current Quarter, Previous Quarter, Quarter 3 from Current year, etc.

Quarters begin on January 1, April 1, July 1 and October 1.

Current year, Previous year, etc.

The year begins on January 1.

If the Start of work day setting is 12:01 p.m. or later, these start dates will be modified to begin at this time on the previous day (e.g., week begins on Saturday evening instead of Sunday).

Default date periods

The settings in this tree determine the default date periods you can set that will be used to retrieve and analyze data in different areas of GainSeeker.

If you choose the date periods that will be used most frequently for these tasks, you will save time because you can avoid manually setting the period when you generate charts, reports and dashboards.

To set any of these default date periods, right-click on the date period in question. This will display the Date Period window.

In most cases, it is preferable to choose a relative date range such as Default low to today, All dates or one of the User select options. Most of these options will adjust the actual dates used to retrieve data, based on the date when the user is retrieving data for the chart, report or dashboard. By contrast, if you set a Fixed range as the default date period, the exact dates you specify will be applied to the data being retrieved, regardless of the date when the user is retrieving the data.

Two of the options on this screen actually reflect other configuration settings:

When setting the default date period for SPC Data Entry, the Fixed range option and some of the User select options are not available.

You may notice that many of the User select options have a different name than their equivalent date periods in most GainSeeker modules, and a few have no equivalent. When you choose a User select option for the default date period, GainSeeker modules such as Enterprise Dashboard, SPC Charts & Reports and DMS Charts & Reports will apply this date period in one of two ways:

For example, if you choose a default date period of Current Day, modules such as Enterprise Dashboard will display a default date period of Today. Similarly, a default date period of Previous Week will be displayed as Last week.

For example, if you choose the User select date period of Specific Week 1 from Current year, modules such as Enterprise Dashboard will display a default date period of Custom by date for the first week of the current year.

Default low date

The Default low date will be used when users analyze data for the date period named Default low to today.

Each time a user analyzes data for the date period named Default low to today, that default low date will be the exact date you specify here:

      1. Right-click the Fixed date node and enter the wanted low date and time.

      2. Expand the Default low date method tree and then click the Fixed date/time node on this tree.

Each time a user retrieves data for the date period named Default low to today, that default low date will automatically be updated relative to the current date/time.

For example, if you set the default low date to subtract three months from the current date/time, then the default low date will always be three months before the date of analysis.

      1. Right-click the Subtract amount node and enter the number of Years, Months, Days, etc. to subtract from the current date/time each time data is analyzed with the date period named Default low to today.

      1. Expand the Default low date method tree and then click the Subtract from current date/time node on this tree.

If you create a new configuration and do not set a default low date, GainSeeker will assume a default low date of January 1 of the previous year instead of storing an actual date for this configuration. This means that at the start of each new year, the GainSeeker will assume a new default low date of January 1 of the previous year.

First day of the week

You can set the First day of the week to either Sunday (the default) or Monday.

In current GainSeeker modules such as GainSeeker Charts, Dynamic Reports, PC Collect, and GainSeeker Utility, this setting affects the following:

This setting does not apply when using Fiscal calendar (very rare).
It also does not apply to legacy GainSeeker modules such SPC Charts and Reports, DMS Charts and Reports, SPC Data Entry, DMS Data Entry, and Enterprise Dashboard.

Fiscal calendar options

If you set the Calendar format to Fiscal 4,4,5 or Fiscal 5,4,4, then you should expand the Fiscal Calendar options tree and configure the following options:

This will be the starting date of your fiscal calendar. For most fiscal calendars, this will be a date other than January 1.

To change this date, right-click this node and enter the correct date.

For some fiscal calendars, the first "week" may be shorter or longer than seven days, so that the remaining weeks on the fiscal calendar can start on a more typical day (such as Sunday or Monday).

You should use this setting to specify the number of days in the first week of the fiscal year.

To change this number, right-click this node and enter the correct number of days in the first week of the fiscal year.

Last 'n' days ending today

One of the predefined date periods is Last n days ending today. You can use this setting to configure the number of days to include in that date period.

For example, if you frequently analyze data that was generated in the last 45 days, you can set this number to 45. Then one of the Date period options available will be 45 days ending today.

To change this setting, right-click this node and enter the number of days you want to use for this date period.

Last 'n' hours ending now

One of the predefined date periods is Last n hours ending now. You can use this setting to configure the number of hours to include in that date period.

For example, if you frequently analyze data that was generated in the last 12 hours, you can set this number to 12. Then one of the Date period options available will be 12 hours ending now.

To change this setting, right-click this node and enter the number of hours you want to use for this date period.

Shift Sequence

This setting is used with the Start of work day (below) to group data by Day/Shift on OEE Charts and DPU charts, and to calculate the Current Shift and Previous Shift date periods.

For details on configuring this setting, see Shift Sequence.

Show time to

To set the precision for displaying time stamps, expand this tree and then click Minutes, Seconds or Hundredths of seconds.

Note:  GainSeeker uses this setting to increment the date/time stamps of data points entered in succession.

If you enter more than one data record per minute, you should display Seconds or Hundredths of seconds. If you may enter more than one data record per second, you should display Hundredths of seconds. Displaying less precision may significantly slow down your system during data entry because of date/time stamp conflicts.

Start of work day

If you want most pre-defined date periods (such as days, weeks, months, etc.) to start at the beginning of the first shift of the day and finish at the end of the last shift of the day, you can set the Hour and Minute when the first shift of the day begins.

The examples below use the Gregorian calendar with the First day of the week set to Sunday.

Work day begins at

Date Period = "Current Day"

Date Period = "Current Week"

0:00 (Midnight)

12:00 a.m. through
11:59 p.m. today

12:00 a.m. last Sunday morning through
11:59 p.m. next Saturday evening

5:30

5:30 a.m. today through
5:29 a.m. tomorrow

5:30 a.m. last Sunday morning through
5:29 a.m. next Sunday morning

12:00 (Noon)

12:00 p.m. today through
11:59 a.m. tomorrow

12:00 p.m. last Sunday afternoon through
11:59 a.m. next Sunday morning

12:01

12:01 p.m. yesterday through
12:00 p.m. today

12:01 p.m. last Saturday afternoon through
12:00 p.m. next Saturday afternoon

23:00

11:00 p.m. yesterday through
10:59 p.m. today

11:00 p.m. last Saturday evening through
10:59 p.m. next Saturday evening