JPH06332599A - Data processor - Google Patents

Abstract

PURPOSE:To automatically generate the real date data by only designating reserve words which have bee decided previously without inputting numerical strings representing the dates. CONSTITUTION:When the reserve words showing the dates are designated from a condition designation part 1, a date data generation part 3 refers to a reserve word table 6 and reads out a correction value corresponding to the reserve word. The part 3 corrects the prescribed reference date based on the correction value and automatically generates the real date data corresponding to the designated reserve word.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing device for processing date data in a personal computer, an office computer or the like.

[0002]

2. Description of the Related Art Generally, an office processing device such as an office computer stores and manages various files such as an accounting file, a personnel file, a sales slip file, and an inventory file. Here, when the user specifies a date or the like as an extraction condition to be output, data corresponding to the specified extraction condition is read from a predetermined file and output. In this case, for example, as shown in FIG. 7, the method of designating the date data is as follows: As shown in FIG.
(March 3), "199302 (February 1993)" was input.

[0003]

However, the method of designating a date while directly inputting a series of numerical values representing "year / month" has a large number of digits, and thus an input error is likely to occur. If you want to output the accounting balance etc. of the previous month every month, you have to input a series of "Monthly" numerical values indicating the previous month on the expected screen for specifying the form output each time you output the form. There were drawbacks such as making mistakes easily and requiring time and labor. An object of the present invention is to make it possible to automatically generate actual date data by simply specifying a predetermined reserved word without inputting a numerical value sequence indicating a date.

[0004]

The means of the present invention are as follows. (1) The table storage means stores a reserved word table in which a reserved word as a substitute character string in place of a date and a correction value for correcting the date are associated with each other. For example, as a substitute character string in place of the date, Reserved words are "current month", "previous month",
"Last month before", "3 months ago" ... "Same month last year". (2) The reserved word designating means is a key input device for designating a predetermined reserved word. (3) When the reserved word designated by the reserved word designating means is a substitute character string for the date, the reading means reads the correction value corresponding to the reserved word from the table storage means. (4) The date data generating means corrects a predetermined reference date based on the correction value read by the reading means to generate actual date data corresponding to the designated reserved word. In this case, the reference date may be the current date data obtained by the time counting means or any date data designated by the date designating means.

[0005]

The operation of the means of the present invention is as follows. Now, when the reserved word as the substitute character string for the date is designated by the reserved word designating means, for example, "3 months ago", the reading means reads the correction value corresponding to the designated reserved word from the reserved word table. Then, the date data generating means corrects the predetermined reference date based on the correction value read by the reading means to generate the actual date data corresponding to the designated reserved word. In this case, date data three months before the reference date is generated. Therefore, actual date data can be automatically generated by simply designating a predetermined reserved word without inputting a numerical value sequence indicating a date.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment will be described below with reference to FIGS. FIG. 1 is a block diagram showing a main part of a data processing device. The condition designation unit 1 is a key input device, and arbitrarily designates a file name, an item name, and a date as an extraction condition of an output target. In the present embodiment, the date is designated by a substitute character string instead of the numerical value column data. I am trying to do it. For example, "current month", "year and month", "three months ago" ...
The date is designated by a substitute character string such as "12 months ago". At this time, this substitute character string may be directly input by a character key, but in the present embodiment, a list of substitute character strings is stored in a table in advance, and when the date is designated, the table contents are displayed in a window. The date is specified by displaying a list on the screen and selecting an arbitrary substitute character string from the list.

The data type designating section 2 is for designating the type when date data is output. When the "year / month" data is output in the year notation, the "year" data is represented by four digits. Select whether to output in formal type or in informal type expressed by the last two digits. Also,
The data type designation unit 2 also designates a reference month. here,
"Reference month" is a substitute character string for the date, "current month"
Indicates the month that serves as the reference month for recognizing, and if the reference month is the current month, specify "0" as the reference month, and if the reference month is one month before the current month, specify "0". If it is 1 "or 2 months ago," 2 "is specified .... If it is 12 months ago," 12 "is specified as the reference month. Even when the output type of the date data and the reference month are arbitrarily designated, the selection candidates corresponding to them are listed on the window screen, and the desired candidate is designated from the list.

The date data generation unit 3 sets the output type and reference month arbitrarily specified by the data type specification unit 2 in the date parameter table 4, and the file name of the output target arbitrarily specified by the condition specification unit 1. And the item name are set in the extraction condition memory 5, and when the condition designating unit 1 designates a substitute character string instead of the date, the date parameter table 4, the reserved word table 6, and the clock circuit unit 7 are referred to. , Date data corresponding to the designated substitute character string is generated and set in the extraction condition memory 5.

The date parameter table 4 is constructed as shown in FIG. 2. In the output type designation area, "0" is selected when a formal type expressing the year of the Christian era in four digits is selected and designated as the output type. Data is set, the bottom 2
When the abbreviation type represented by digits is selected and designated, the data of "1" is set. Further, data of "0" to "12" is set in the reference month setting area according to the designated reference month.

The reserved word table 6 is constructed as shown in FIG. That is, the reserved word table 6 has a table configuration in which reserved words as substitute character strings instead of dates are associated with correction values for correcting dates. For example, "current month", "previous month", "two months before", "three months ago" ... "12
Correction values “0”, “1”, “2”, “3” ... “13” are stored corresponding to the reserved word names of “Before month” and “Same month of the previous year”. That is, this correction value is a correction value for specifying the month prior to the current month in units of one month, and in the present embodiment, 13 is counted from the current month (reference month).
Corrections are made up to the month before (the same month last year).

The clock circuit unit 7 obtains the current date data (system date) based on the clock signal for clocking, and the date data generation unit 3 fetches the "year / month" data from the clock circuit unit 7. The data extraction unit 8 searches the file 9 based on the file name, the item name, and the date data indicating the extraction condition of the output target set in the extraction condition memory 5, and records the record data that matches these conditions to the file. It is extracted from 9 and given to the data output unit 10.

Next, the operation of this embodiment will be described with reference to FIGS. FIG. 4 is a flowchart showing the operation of the date data generator 3. First, the user arbitrarily specifies the date data generation parameter from the data type specification unit 2. In this case, the selection candidates are displayed in a list corresponding to the output type of the date and the reference month, and the desired candidate is designated from the list. The output type and the reference month designated by this are set in the date parameter table 4 after being fetched by the date data generator 3 (step S).
1). Here, in the example of FIG. 2, it is shown that "1" is set in the setting area of the date parameter table 4 corresponding to the output type, and the informal type that represents the "year" of the Christian era by the last two digits is specified. Further, "0" is set in the designated area corresponding to the reference month, indicating that the current month is designated as the "current month" of the reserved word indicating the date. Next, the user arbitrarily specifies the extraction condition of the data output target from the condition specifying unit 1. For example, as shown in FIG. 5, if a reserved word (current month) indicating a date is specified in addition to the output target file name (accounting balance file), item name (account item), these specified conditions will generate date data. It is taken into the unit 3 (step S2). It should be noted that even when the reserved word indicating the date is designated, the selection candidates are displayed in a list, and a desired candidate is selected from the list to designate the reserved word.

When the extraction condition to be output is designated in this way, the date data generator 3 checks whether or not the reserved word indicating the date is included therein by referring to the reserved word table 6. (Step S3). If the reserved word indicating the date is not included, the designated conditions are written in the extraction condition memory 5 as they are (step S9), but if the reserved word indicating the date is included, the date data generation unit 3 performs the processing of steps S4 to S8 in order to generate the actual date data corresponding to the reserved word.

First, the date data generator 3 reads out the correction value corresponding to the designated reserved word from the reserved word table 6 (step S4), and accesses the clock circuit 7 to measure the current "year / month". The information (system date) is read (step S5). And the date parameter table 4
The reference month set to is read out, and the system date is corrected based on this reference month (step S6). Here, assuming that the year of the system date is “Y ₀ ”, the month is “M ₀ ”, the reference month is “BASE”, the corrected year is “Y ₁ ”, and the month is “M ₁ ”, (1), _{M 0 -BASE> 0 Y 1 =} Y 0, M 1 = M 0 -BASE (2), M 0 -BASE ≦ 0 Y 1 = Y 0 -1, the correction calculation of M ₁ = M ₀ -BASE + 12 is carried out . Now, the system date is "199
If the reference month is “0” in “May 3rd year”, the above formula (1) is calculated, and the corrected year “Y ₁ = 1993”, month “M ₁ = May”, that is, , The current date is the current month as it is, but when the reference month is “6”, the above formula (2) is calculated, and the corrected year “Y ₁ = 1992” and month “M ₁ = 1”
January ”, the current date is changed by the reference month, and this date becomes the current month.

After correcting the current month by changing the system date by the reference month, the date is corrected based on the reserved word (step S7). Assuming that the correction value set in the reserved word table 6 is “COR”, the corrected year is “Y ₂ ”, and the month is “M ₂ ” (3), M ₁ -COR> 0 Y ₂ = Y ₁ , M ₂ = M ₁ −COR (4), M ₁ −COR ≦ 0 Y ₂ = Y ₁ −1, M ₂ = M ₁ −COR + 12 The correction calculation is performed. If the date of the current month obtained in step S6 is “February 1993” and “previous month” is designated as the reserved word (correction value is “1”), the following formula (3) is used. Calculation is performed and the corrected year "Y ₂ = 1"
993 ", the month" M ₂ = January ". If "3 months ago" is specified as the reserved word, the correction value is "3", so the above equation (4) is calculated and the corrected year "Y"
₂ = 1992 "and the month" M ₂ = November ". In this way, the correction is performed to change the date of the current month by the number of months indicated by the correction value corresponding to the reserved word.

Next, the date data generator 3 refers to the output type set in the date parameter table 4, and matches the date data "Y ₂ , M ₂ " corrected in step S7 with the set output type. The data structure is changed (step S8). In this case, if the simplified type is set, the date data “Y ₂ , M ₂ ” after correction is changed to date data with the upper 2 digits of the year removed. The date data newly generated in this way is set in the extraction condition memory 5 together with the file name and item name previously specified as the extraction condition of the output target (step S9). In this state, when a data output command is given, the data extraction unit 8 refers to various extraction conditions in the extraction condition memory 5, reads the corresponding data from the file 9, and causes the data output unit 10 to output the data.

As described above, in the present embodiment, desired date data in the Western calendar notation can be automatically generated only by specifying a reserved word indicating a date without actually inputting a numerical value sequence indicating a date. You can Therefore, for example, as shown in FIG. 7, it is not necessary to register the actual date data “199303” and “199302” as the condition value of the condition item “year / month degree”, and as shown in FIG. As it is only necessary to specify "current month" and "previous month", it becomes extremely easy to specify the date.

In the above embodiment, the date data in the Western calendar is automatically generated, but the date data in the Japanese calendar may be automatically generated. Further, in the above embodiment, the reserved word names set in the reserved word table 6 are represented in units of one month, but the reserved word names may be represented in units of week, day, or year. Further, in the above embodiment, when the reference month is set before the current date, the date is traced back one month before the reference month, two months before, etc., according to the reserved word. , The date after the reference month,
In other words, if reserved words such as one month ahead and two months ahead are set, dates ahead of the reference month can be generated according to the reserved words.

[0019]

As described above, according to the present invention, actual date data can be automatically generated by simply designating a predetermined reserved word without inputting a numeric string indicating a date. , Especially when frequently inputting the date such as accounting work, for example, when trying to output the form of the previous month every month, it suffices to specify the "previous month" reserved word, which is a laborious task of inputting the date. It is possible to carry out accounting tasks accurately and efficiently.

[Brief description of drawings]

FIG. 1 is a block diagram of a data processing device according to an embodiment.

FIG. 2 is a diagram showing a configuration of a date parameter table 4.

FIG. 3 is a diagram showing a configuration of a reserved word table 6.

FIG. 4 is a flowchart showing the operation of the date data generator 3.

FIG. 5 is a diagram specifically showing a case where an extraction condition of an output target is designated.

FIG. 6 is a diagram specifically showing a case where a reserved word indicating a date is designated.

FIG. 7 is a diagram specifically showing a case where a date is conventionally designated as an extraction condition item.

[Explanation of symbols]

 1 Condition designation part 2 Data type designation part 3 Date data generation part 4 Date parameter table 5 Extraction condition memory 6 Reserved word table 7 Clock circuit part

Claims (2)

[Claims] 1. A table storage means for storing a reserved word table in which a reserved word as a substitute character string instead of a date and a correction value for correcting the date are associated with each other, and a reservation for designating a predetermined reserved word. A word designating means, a reading means for reading out a correction value corresponding to the reserved word from the table storing means when the reserved word designated by the reserved word designating means is a substitute character string for the date; Date data generating means for generating actual date data corresponding to the designated reserved word by correcting a predetermined reference date based on the correction value read by Data processing device. 2. The data processing device according to claim 1, wherein the reference date is current date data obtained by a time measuring means.