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 ...
For Each Day with TimeStamp - Bug?
-
- Posts: 619
- Joined: Wed Jun 17, 2015 11:16 pm
- Location: Omaha, Nebraska
- Contact:
For Each Day with TimeStamp - Bug?
VocalDay Solutions - Agility - Predictability - Quality
We specialize in enabling business through the innovative use of technology.
AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
We specialize in enabling business through the innovative use of technology.
AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
-
- Posts: 2405
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: For Each Day with TimeStamp - Bug?
Try updating the EndTime as a RULE
Scheduled_ObjectActivity IS NEW
Scheduled_ObjectiveActivity.EndTime = DATE_ADD(Scheduled_ObjectiveActivity.StartTime,1)
Scheduled_ObjectActivity IS NEW
Scheduled_ObjectiveActivity.EndTime = DATE_ADD(Scheduled_ObjectiveActivity.StartTime,1)
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
-
- Posts: 619
- Joined: Wed Jun 17, 2015 11:16 pm
- Location: Omaha, Nebraska
- Contact:
Re: For Each Day with TimeStamp - Bug?
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.
For Each Week and For Each Month work as expected, so this seems it must be a bug.
VocalDay Solutions - Agility - Predictability - Quality
We specialize in enabling business through the innovative use of technology.
AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
We specialize in enabling business through the innovative use of technology.
AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
Re: For Each Day with TimeStamp - Bug?
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
For each number between 1 and daydifference variable. Then just reconstruct your timestamps.
Cheers Rod
-
- Posts: 619
- Joined: Wed Jun 17, 2015 11:16 pm
- Location: Omaha, Nebraska
- Contact:
Re: For Each Day with TimeStamp - Bug?
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.
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.
VocalDay Solutions - Agility - Predictability - Quality
We specialize in enabling business through the innovative use of technology.
AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
We specialize in enabling business through the innovative use of technology.
AwareIM app with beautiful UI/UX - https://screencast-o-matic.com/watch/crfUrrVeB3t
Re: For Each Day with TimeStamp - Bug?
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
Cheers Rod