# To get this year/week start date and end date from Year & Week No?

My input is Year and Week No.  How to get this year/week start date and end date?
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
year start = trunc(to_date(in_year,'yyyy'),'yyyy')

week start/week end - this is tricky,  what do you consider the start of a week?

if weeks count from day 1 of the year, then try this...

week start = trunc(to_date(in_year,'yyyy'),'yyyy') + (7 * (in_week - 1))
week end =  trunc(to_date(in_year,'yyyy'),'yyyy') + (7 * (in_week - 1)) + 6

if weeks count from the first Monday of the week (ISO weeks)

week start = next_day(trunc(to_date(in_year,'yyyy'),'yyyy') -1,'Mon') + (7 * (in_week - 1))
week end = next_day(trunc(to_date(in_year,'yyyy'),'yyyy') -1,'Mon') + (7 * (in_week - 1)) + 6

if weeks count from some other rule, post what you're using and I'll try to figure out how to represent it
0

Experts Exchange Solution brought to you by