For Each Day with TimeStamp - Bug?

johntalbott

CREATE BO FOR EACH DAY is incrementing TimeStamps by Hours rather than Days.

The following code ...

CREATE Scheduled_ObjectiveActivity FOR EACH DAY BETWEEN ObjectiveActivity.StartTime AND ObjectiveActivity.RecurrenceEndDate WITH Scheduled_ObjectiveActivity.ObjectiveActivity = ObjectiveActivity, Scheduled_ObjectiveActivity.Subject = ObjectiveActivity.Subject, Scheduled_ObjectiveActivity.StartTime = LOOP_ITERATION, Scheduled_ObjectiveActivity.EndTime = DATE_ADD(LOOP_ITERATION,1)

Is producing ...

customaware

Try updating the EndTime as a RULE

Scheduled_ObjectActivity IS NEW

Scheduled_ObjectiveActivity.EndTime = DATE_ADD(Scheduled_ObjectiveActivity.StartTime,1)

johntalbott

I can try that as a workaround, but I'd rather keep everything in the process as it's part of a larger If ... Else.

For Each Week and For Each Month work as expected, so this seems it must be a bug.

RocketRod

I notice that your date range is between a timestamp and a date attribute? If so try DATE_PART(ObjectiveActivity.StartTime). Also I usually get the day difference first between the dates and then do a

For each number between 1 and daydifference variable. Then just reconstruct your timestamps.

Cheers Rod

johntalbott

Thx Rod. The RecurrenceEndDate is also a TimeStamp. The DATE_PART suggestion is valid though.

Interestingly enough after my last post ... I wrapped both dates with DATE_PART and that did the trick.

It still seems like a bug to me.

RocketRod

Great, glad its all ok now. As to if it's a bug depends on if FOR EACH DAY expects dates or timestamps. Only Support can answer that.

Cheers Rod