How to add 10 days to a mdyy/ field

Bruce Easton bruce at stn.com
Thu Jun 7 20:39:23 PDT 2012


On 6/7/12 9:07 PM, Kenneth Brody wrote:
> On 6/7/2012 6:27 PM, Bruce Easton wrote:
>> And to correct my second question, I really meant:
>> What happens if, in adding to an eight-digit date,
>> you *surpass* the point where the current setting of PFCMARK
>> would throw you back into the 1900's?
> [...]
>
> By "8-digit date", I am assuming you mean "2-digit year, with 
> slashes", such as (8,mdy/).
>
> If date math exceeds the range of the 2-digit year, you should get "/OV".
>
> My system has PFCMARK=20, and using the following:
>
> =====
> ::end:
> @entsel::xx(8,mdy/) = "12/01/19":
> ::yy(10,mdyy/) = xx:
> ::zz(8,mdy/) = xx + "40":
> ::show "'" & xx & "'" & yy & "'" & zz & "'":
> ::end:
> =====
>
> shows:
>
>     '12/01/19'12/01/2019'/OV     '
>
Looks like it's a difference between rclerk and dclerk.

I get the results you got with dclerk:

'12/01/19'12/01/2019'/OV     '

but with rclerk, I get:

'12/01/19'12/01/2019'01102020'

(similar to what I had posted. Note that  the result was even
weirder from rclerk when when the result field is 10,mdyy/.)

I also tested this on 5.7 Linux - same thing.

Bruce





More information about the Filepro-list mailing list