How to add 10 days to a mdyy/ field

Kenneth Brody kenbrody at spamcop.net
Thu Jun 7 18:01:46 PDT 2012


On 6/7/2012 3:10 PM, Henry Arredondo wrote:
> It's (8,mdy/)

Then something else is going on that you're not showing us.

Does field 5 contain today's date?  (And what is PFCMARK set to?)

If field 5 is (8,mdy/) and contains "06/07/12", then the result of:

     5 + "10"

is the date "06/17/12".  If field dd is (10,mdyy/) then

     dd = 5 + "10"

will result in "06/17/2012" being stored in field dd.  (Or "06/17/1912", 
depending on PFCMARK.)

Add the following immediately after the assignment:

     mesgbox "'" & 5 & "' " & fieldlen(-,"5") < fieldtype(-,"5")
         & "\n'" & dd & "' " & fieldlen(-,"dd") < fieldtype(-,"dd")

> -----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
>
>
> 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 ?

-- 
Kenneth Brody


More information about the Filepro-list mailing list