Week Number to Date Formula?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I have a set of data that has week numbers instead of dates, and I'm trying to add a column with a date to go onto do time series forecasting. I imagine it's possible to input start date and keep adding 7 days, but I will eventually be using files with different starting week numbers so if it's possible to avoid doing this for every file that would be best! I know there are ways to go from a date to a week number, but I haven't used Alteryx enough to know if there's a way of doing it the other way around? Thanks!
Solved! Go to Solution.
- Labels:
- Date Time
- Time Series
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rachel9989 ,
Do you have the information about the year ? Or do you have only a column with week numbers as 1,2,3...51,52 ?
Cheers,
Jean-Baptiste
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How would I make this work for data that spans 2-3 years?
For example, I could have 2 records with week "12," but one record has a value with 2012 in the year field and the other record has 2013 as the year.
