Merge/Join: Creating min/max day sequence from date range?
-
I have a column with a start date and one with an end date. The format in both these fields is the same. What I would like to do is turn the start and end date into a list which contains every single data between the start and the end date
Any suggestions?
Thanks - Anna
-
1 Comment
-
Similarly to example posted here http://forums.visokio.com/discussion/comment/7974/#Comment_7974
you should create a Date Sequence block (set start date to min date in your series), max to most recent, then do merge on two fields ([Start date] and [End date]), ticking the option to publish the matches, so only those values from the sequence that match both min/max criteria.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.