Tagged with week-counts - Visokio Forums http://forums.visokio.com/discussions/tagged/week-counts/feed.rss Mon, 30 Oct 17 15:44:37 -0400 Tagged with week-counts - Visokio Forums en-CA Date/ week calculation: Date minus an integer http://forums.visokio.com/discussion/3166/date-week-calculation-date-minus-an-integer Wed, 24 Aug 2016 07:40:38 -0400 craven99 3166@/discussions
I have a week field - which was duplicated from a standard date field and works fine. But our payroll team work on a back week so they wish the filter to be the current displayed week minus 1 week. So Omniscope is correctly stating week 34 - but my team need it to show week 33. Can for the life of me figure out how to get the field to show this - am I missing something simple?]]>
Formulae: Calculating Week Start - Week Ending dates? http://forums.visokio.com/discussion/2719/formulae-calculating-week-start-week-ending-datess Wed, 17 Sep 2014 13:48:34 -0400 Panos 2719@/discussions Is there any formula so I can get the "week start" or "week end" for each week number?
Regards,
Panos]]>
Date/Time: Week 1 2013 in Week Format? http://forums.visokio.com/discussion/1978/datetime-week-1-2013-in-week-formats Thu, 10 Jan 2013 06:16:48 -0500 EnyaVDW 1978@/discussions
I am having a problem with changing week one of 2013 from text field into a date/time field.

As you can see in this first screenshot, I already have my year-week data as a text field.

image

I would like to change this into a date/time field because I'm doing a weekly update for a client since 2011 and the 2011 and 2012 data/time data contains a date/time field and no text field. All data has to have the same type of field of course. So there is no option to leave this data in text field for 2013... When I change my year-week field into date/time, it changes all data except the first week of 2013, it leaves those cells blank... (See image below)

image

I do not have version 2.8 yet because it is still in its testing phase. Neather can I use the function you have mentionned in another discussion because that will leave my column in a text field.

Do you have any idea how to solve this problem?
Or should I install the 2.8 version to be sure that it works? I am just a little bit scared that it will change my data of 2011-2012 because of some new options.

Thanks in advance,

Enya]]>
Date/Time: 2013 Dates in Week Format? http://forums.visokio.com/discussion/1966/datetime-2013-dates-in-week-formats Wed, 02 Jan 2013 17:06:57 -0500 hgross 1966@/discussions
Any help you can offer would be great. Thanks.]]>
Week numbering in Field Organiser http://forums.visokio.com/discussion/808/week-numbering-in-field-organiser Thu, 09 Jun 2011 05:31:31 -0400 Louise_Peers 808@/discussions Week Formatting http://forums.visokio.com/discussion/1031/week-formatting Fri, 30 Sep 2011 17:04:45 -0400 hgross 1031@/discussions
It is only working for certain rows and I'm not too sure why. Any suggestions?

[Pic attached]]]>
01-2011 is not recognised as week? http://forums.visokio.com/discussion/712/01-2011-is-not-recognised-as-weeks Mon, 18 Apr 2011 09:53:45 -0400 Miklos 712@/discussions
Can you guys please give me a solution for this problem? Why does my Omniscope think that there is no first week in 2011? :) Thanks, Miklos
]]>