The following case command returns the begin of the first week of year:
#Week number for 2015 iso
The first week of a year (by ISO stabdard) is the week with the first Thursday of the year in it. If you have a NUMBER value p_YEAR, you can calculate the weekday of the 1. Select to_char ( date'' + level, 'day' ) dy, Whether you add or subtract depends on which day you consider to be the start of the fiscal year: You can convert these to Saturday - Friday weeks by either adding 2 or subtracting 5 from the date, then converting to the ISO week. How can the week start with Saturday and end on Sunday?! That's either a 2 day or 8 day week! (SELECT MAX(C_ED.EFFDT) FROM PS_SCH_DEFN_TBL C_EDĪND B.DAYNUM = (MOD((TO_DATE( A.START_DT,'YYYY-MM-DD') - TO_DATE( C.EFFDT,'YYYY-MM-DD')), C.SCHEDULE_DAYS))+1ĪND TO_CHAR(TO_DATE( A.START_DT,'YYYY-MM-DD'),'YYYY') = :1 ) (SELECT MAX(B_ED.EFFDT) FROM PS_SCH_DEFN_DTL B_ED TO_CHAR(TO_CHAR(TO_DATE( TO_CHAR(A.START_DT,'YYYY-MM-DD'),'YYYY-MM-DD'),'WW') + 0)ĮND, TO_CHAR(TO_DATE( TO_CHAR(A.START_DT,'YYYY-MM-DD'),'YYYY-MM-DD'),'d'), TO_CHAR(A.START_DT,'YYYY-MM-DD'), B.SCHEDULE_ID, B.SCHED_HRSįROM PS_TL_CALENDAR A, PS_SCH_DEFN_DTL B, PS_SCH_DEFN_TBL C I can then drop the results into a BI Pub and out comes a calendar grouped by month then week and I can see how many hours employees are scheduled for across a calendar year. Select to_char(dt, 'YYYY-MM-DD dy "IYYY"=IYYY "IW="IW "WW="WW') output WW starts January 1st, but not following Mon-Sun weeks or Sun-Sat weeks, but weeks using WW shift on the day that is January 1st, so using WW in 2016 makes weeks go from Fri-Thur.įinding the week number according to US standard - well as far as I know such a format model element does not exist? Or maybe I have just never encountered it? Then the first week of 2016 begins Monday.
#Week number for 2015 code
That being the case, I would like him to confirm the formula he is using, and to post the code used in the formula The only thing I can think of is that there is something in that other formula that is impacting the result.In ISO standard "Week 53-2015" goes from Monday to Sunday. At this point, and assuming I understand the OP's issue (and I'm not certain I do), it seems the real issue is that the OP's CR installation is returning a different result to mine. In effect, Week 53 of 2015 and week 1 of 2016 represent the same 7 days. Without ever having needed the function, it is doing what I would have expected in that the first 3 days of Jan 2016 are week 1, changing to week 2 on Monday 4 January 2016. At this stage all I am saying is what my installation of Crystal (v11) is returning using the formula the OP says is being used. I haven't personally ever needed to use week numbers in any of the reporting I have ever done. Yes you are correct in that the formula returns week 53 for, Week 1 for and Week 2 for.
0 kommentar(er)
