Forum Discussion
Dan80
Helper II
Helper IIConvert date ranges into list of dates?
Hi all, I have a table with 2 columns, start date and end date of sales campaigns but I need to convert the range into a list of dates, ie one column of all dates we have been on sale. Any ideas how t...
In M it can be done in various ways but the easiest would be to:
- convert start and end dates to numbers,
- create lists from those numbers,
- expand the lists and
- convert the numbers back to dates
as demonstrated in this short video.
MarcelBeug
Community Champion
Community ChampionIn M it can be done in various ways but the easiest would be to:
- convert start and end dates to numbers,
- create lists from those numbers,
- expand the lists and
- convert the numbers back to dates
as demonstrated in this short video.
Dan80Helper II
Helper IISensational, thanks so much for your help!