The JP modifier is used with DATE to compare two Japanese dates. The following Japanese style dates can be used and will be automatically converted to YYYYMMDD format:
- 昭和30年1月1日
- 1997年1月1日
- 1997-1-1
- S35-1-1
|
Score |
Description |
|---|---|
|
100 |
The dates are equal and neither is zero. |
| 75 |
Case 1: both years and months are equal; years and months are not zero. Case 2: both months and days are equal; months and days are not zero. Case 3: both years and days are equal; years and days are not zero. |
| 50 |
Case 1: either field is blank. Case 2: value of month >12 or value of day >31. Case 3: value of day =<0 and month or year =<0, or all three values =<0. |
| 5 |
All other cases |
| 0 |
The difference of the year >=16 and months and days are not equal. |