Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Friday, November 17, 2017 11:41:31 AM(UTC)
Rank: Newbie

Groups: extranet\Forum
Joined: 10/16/2017(UTC)
Posts: 3

Hi I am posting this after spending a while banging my head against an issue with dynamic dates.

I am trying to define some criteria to show aggregations for a number of previous fiscal weeks. I am using the offsets to specify year and week times but there comes a point where the offset doesn't make a difference. e.g.

Week - 1 resolves to (Week 2 2018 (WE 11/11/2017)) - which is correct for our fiscal periods
Week - 2 resolves to (Week 1 2018 (WE 04/11/2017)) - correct again
Week - 3 resolves to (Week 52 2017 (WE 28/10/2017)) - correct
Week - 4 resolves to (Week 52 2017 (WE 28/10/2017)) - shouldn't it be week 51?
Week - 5 resolves to (Week 52 2017 (WE 28/10/2017)) - still week 52

(Images attached)

It follows this pattern for every offset beyond what resolves to week 52.

Does anyone know what I've got wrong here?

Any help would be greatly appreciated.

Thanks, Jon.
#2 Posted : Monday, December 4, 2017 8:26:14 AM(UTC)
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514

Hi Jon,

Since you haven't got any reply to this yet, I think it is better to take it to the official TARGIT support (accessible from the TARGIT web page). Some times, these dynamic criteria related to an offset fiscal year may be quite a pain to resolve.

BR / Ole
Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.