AddLines not working as expected
Jay Schille
jayschille at gmail.com
Tue Apr 15 23:15:34 PDT 2008
Thanks, Michael, for confirming.
>Jay
>
>Nobody else has shown any interest in this so I had a look at it.
>You are correct - using "M" as the bump parameter adds the expected
>number of new records but each is the first day of the expected month
>rather than the day specified in the start parameter. Similarly, if
>"Y" is used as the bump parameter, each new record is the first day of
>the expected year.
>
>Certainly a bug - Jim or Dave might like to confirm this.
>
>michael
>
>
>On 15/04/2008, at 3:15 AM, Jay Schille wrote:
>
>> Here's what I've got going:
>> (EventDate is a date field in the database)
>>
>> local oDate
>> oDate=date("04/15/08")
>> if HowOften="monthly"
>> AddLines EventDate, monthmath(oDate, 1), monthmath(oDate,
>> 8), "M", 1
>> endif
>>
>> This produces eight new records, the first of which, as expected, has
>> the EventDate of "05/15/08." But the next seven records have
>> EventDates sequenced as "06/01/08," "07/01/08"... Not what I want.
>>
>> Is this a bug or a feature or am I not using the procedure correctly?
>> --
> > Jay Schille
--
Jay Schille
More information about the Qna
mailing list