Find week number since epoch
673975Dec 4 2008 — edited Dec 5 2008Hello,
I'm trying to find the week number of a given date since epoch, but all of my searches in Google, etc, seem to return a week number of a given date of a specific year.
For aggregating purposes, we want to be able to group things up by their week number, not by individual year, since the dates will range multiple years.
So that, 1/1/1970 will return 1
And 12/4/1971 will return 101
And so on.
(In MM/DD/YYYY format)
Is there an internal function existing already to do this? From what I've found there isn't, but I'm far from an expert.
Any help would be appreciated, thanks.
--Kevin