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.

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:

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:

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:

• The default low date used by Default low to today

• In the User select area, if you choose the Type of period called Ending now, then you can choose a Length of 24 hours or another number of hours. This second number of hours is configured by the Last 'n' hours ending now setting.

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:

• If you choose a User select date period that has an equivalent date period in modules such as Enterprise Dashboard, then this date period will be applied to the retrieved data as a relative date.

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.

• If you choose a User select date period that does not have an equivalent date period in modules such as Enterprise Dashboard, then this date period will be applied to the retrieved data as a fixed date.

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.

1. • One option is to set the default low date to a fixed date and time – such as January 1 of the current year.

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. 1. 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.

   • The other option is to set the default low date to subtract a specific amount of time – such as three months – from the current date at the time of data retrieval.

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.

2. 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:

• Date period set to Previous Week

• Date period set to Current Week

• Date period set to any Specific Week option

• SPC data grouped by week

• DPU data grouped by week

• OEE data grouped by week

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:

• Start date for fiscal year

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.

• Number of days in first week

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.

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.