Visokio website     Downloads     Video tutorials     KnowledgeBase  
Merge/Join: Creating min/max day sequence from date range? - Visokio Forums
Merge/Join: Creating min/max day sequence from date range?
  •     ALC March 27, 2014 1:05PM
    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
  •     paola March 27, 2014 1:28PM
    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!

Sign In Apply for Membership

Tagged