views:

196

answers:

2

I have the ISO week and year but how do I correctly convert that into two dates representing the start and end of that week?

+1  A: 

there are a couple of strategies to do that. after a quick search on the web i've found these:

vitorsilva
A: 

If you've got some SQL chops, you could prune relevant bits from F_TABLE_DATE. Or, if you like having a monster function around, you could just use the whole shebang. You'd have to manufacture a sensible start and end date to pass into F_TABLE_DATE though.

Dan F