Skip to main content

Hi Everyone,

 

I have project start date and project end date, like this.

Proj Number          Proj Start date                 Proj End Date

123                         17-05-2018                     08-10-2018

1234                       21-02-2018                     04-12-2018

 

Here i want to display the weeks between these two dates

eg.,  for 1st project , week 20 to week 41. So i should display all week 20  week 21  week 22 week 23 till week 41 or either i should display the dates(like week starting date)

 

Any idea please let me know.

 

This question was unanswered from 2018 Display all the weeks between two dates, Any insights will be much appreciated.

6 answers
  1. Nov 20, 2019, 8:32 PM

    the usual solution is to create a date scaffold

    I keep a 2 date problem solution on my public site at Tableau Public

    if includes step by step how to instructions and returns this

     

    the usual solution is to create a date scaffold I keep a 2 date problem solution on my public site at Tableau Public if includes step by step how to instructions and returns this feel free to download

     

    feel free to download it an use it as a model - that's why it is there

    Jim

    If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

0/9000