RockWorks | Utilities | Coords | Dates -> Stardates
This program is used to translate dates listed as month/year, month/day/year, or day/month/year into a decimal-style "stardate". Most typically this is used if you wish to plot date-dependent data along an axis of an XY plot, and the application requires that dates be entered in decimal format.
Menu Options
Step-by-Step Summary
Menu Options
- Input Columns: Date: Select the name of the column in the datasheet that contains the dates to be translated.
- Output Columns: Stardate: Select the name of the column in the current datasheet into which the program is to record the reformatted dates. Be warned that any existing data in this column will be overwritten.
- Input Format: There are two types of input formats that this program accepts; Month/Day/Year, and Month/Year.
-
- Month/Year: Acceptable Month/Year formats are shown by the following examples:
-
- Mar/92
- Sep-2002
- Mar-98
- December/66
- Month/Day/Year: Acceptable Month/Day/Year formats are shown by the following examples:
-
- 9/19/55
- 6/30/1962
- 6-15-82
- Previous Century: If this box is checked, two-digit year dates greater than 50 will be assumed to be in the previous century.
-
- De-Activated: 2/2/98 = 2/2/2098
- Activated: 2/2/98 = 2/2/1998
- Decimals: Define the number of decimal places to be stored in the output dates. Here are some examples:
-
- These dates are set to 10 decimal places:
01/02/90 1990.0054931641
01/10/1990 1990.0273437500
02/05/90 1990.0970458984
02/16/90 1990.1271972656
03/05/90 1990.1804199219
03/16/1990 1990.2104492188
- These dates are set to 5 decimal places:
01/02/90 1990.00549
01/10/1990 1990.02734
02/05/90 1990.09705
02/16/90 1990.12720
03/05/90 1990.18042
03/16/1990 1990.21045
Step-by-Step Summary
- Access the RockWorks Utilities program tab.
- Open or create a data file containing the dates to be translated.
- Select the Utilities | Coords | Dates->Stardates menu option.
- Enter the requested menu items, described above.
- Click the Process button to continue.
The program will translate the dates to decimal dates and store them in the selected columns in the datasheet.
Back to Coords Menu Summary
RockWare home page