Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sqlpuzzle
Contributor III
Contributor III

year and weekofyear to MMM-dd-YYYY format

Hi,

 

I have a data set that has  year and weekof year in it. I need to derive two fields,

week begin date (MMM-dd-YYYY) format

week end date (MMM-dd-YYYY) format.

Is this possible?

I am attaching my sample

Labels (1)
1 Solution

Accepted Solutions
ThePeterK
Creator
Creator

Does this get you what you need?:

 

=weekstart(date(YearStart(makedate(2019))+weekofyear*7))

=weekend(date(YearStart(makedate(2019))+weekofyear*7))

93/93

View solution in original post

1 Reply
ThePeterK
Creator
Creator

Does this get you what you need?:

 

=weekstart(date(YearStart(makedate(2019))+weekofyear*7))

=weekend(date(YearStart(makedate(2019))+weekofyear*7))

93/93