How to add 10 days to a mdyy/ field

[Bruce Easton]

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?

And I did some testing using fp version 5.0.14.

Using the assignment: dd(8,mdy/)=1 + "10", where
PFCMARK=13, and having test file field 1 contain "12/28/12",
with edit 8,mdy/ - the result of dd is: 01072013
(took out slashes but otherwise seems like correct date).

Using the assignment: dd(10,mdyy/)=1 + "10", where
PFCMARK=13, and having test file field 1 contain "12/28/12",
with edit 8,mdy/ - the result of dd is: 0107201913
(took out slashes, kept part of both centuries, and
had the right year - I think).

But in both these cases, I was surprised to see that it
showed data in these data-type fields with
edits 8,mdy/ and 10,mdyy/ respectively,
without the delimiters.

In both cases, I used @key in rclerk to trigger the date math and
an errorbox to show the value of dd.

Bruce



On 6/7/12 3:46 PM, Bruce Easton wrote:
> Correction to my first question - I meant a dummy in automatic
> processing whose declaration is overriding the dd(10,mdyy/)
> that you are trying to use for the result.
>
> Bruce
>
> On 6/7/12 3:36 PM, Bruce Easton wrote:
>> Interesting.  Then I would think your assignment should
>> leave field dd with a date in it as long as field 5 has
>> a valid non-blank value in it.
>>
>> Is it possible that you have a dummy field dd in
>> automatic processing whose declaration is overriding
>> the 8,mdy/ edit that you mention?
>>
>> Also, and this is really a question for Ken, what
>> happens to the value of an 8-digit date if it is
>> approaching the PFCMARK limit as the result
>> of adding days to a date?
>>
>> Bruce
>>
>> On 6/7/12 3:10 PM, Henry Arredondo wrote:
>>> It's (8,mdy/)
>>>
>>> -----Original Message-----
>>> From: Robert T. Repko [mailto:rtr at rsquared.com]
>>> Sent: Wednesday, June 06, 2012 2:59 PM
>>> To: Henry Arredondo
>>> Cc: filepro-list at lists.celestial.com
>>> Subject: Re: How to add 10 days to a mdyy/ field
>>>
>>> What is field 5's edit
>>>
>>> Robert T. Repko
>>> R Squared Consultants
>>> 4 Juniper Ave.
>>> Easton, PA 18045
>>> 610.360.1117
>>>
>>> On Jun 6, 2012, at 3:43 PM, "Henry Arredondo"<hxarredondo at LKQCORP.com>    wrote:
>>>
>>>> Is there an easy way of adding days to date fields ?
>>>>
>>>> I tried:
>>>>
>>>> 5=@t4; Dd(10,mdyy/)=5+"10";
>>>>
>>>> But dd is always blank. How come ?
>>>>
>>>> Thanks
>>>>
>>>> Please consider the environment before printing
>>>> _______________________________________________
>>>> Filepro-list mailing list
>>>> Filepro-list at lists.celestial.com
>>>> Subscribe/Unsubscribe/Subscription Changes
>>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>> This email was scanned for viruses by ClamAV AntiVirus.
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changes
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>