compare current date with fixed date

[tdilling]

How do I compare the current date (not in a column) with a date within a column?  I am using it within a Table visual.  We have a start date and what to know how many days the project has been open, with updating everyday.

[v-yuta-msft]

Hi tdilling ,

Can you show some sample data and clarify more details about your expected requirement?

Regards,

Jimmy Tao

[tdilling]

There is a column of previous dates 12/2/2017, etc.  We want to count the number of days from today's date (rolling date so if it is opened in a week it would use that date) from the date it was opened.

The 12/2/17 date would be 268 days.

Then with that column we would be able to list the longest date.

[tdilling]

How do I compare the current date (not in a column) with a date within a column?  I am using it within a Table visual.  We have a start date and what to know how many days the project has been open, with updating everyday.