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