AddLines not working as expected

Michael audax at wideband.net.au
Tue Apr 15 17:12:03 PDT 2008


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
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna



More information about the Qna mailing list