I have a query in which I convert a date to it's week of the year "ww". When I am writting the code to run directly on the Oracle Tables I use:
To_Char(To_Date("Some_Date",'MM/DD/YYYY'),'WW') as WkOfYear
In Access I am doing this:
Format(qryTemp_Data!Some_Date,"ww") AS WkOfYear
What I have found is that for the 4th of February, Oracle says it is the 5th week, but Access says it is the 6th. I know that the 5th of February would actually be the true 6th week, and Oracle changes to the 6th week on that day, but I am curious what each looks at and is there a way to make it so that the full "Work Week" is the same in Oracle and not split up?