Forum Discussion
Solved
Finding days between project status changes
I have tried a number of things to try to make this work but I can not seem to figure it out. I have a project table which holds the created date for a project and a status table which holds status c...
ConnorH , What output you need. You have created date and status date with you, you can take a date diff.
new column = Datediff([created_date],[status change date],day)
In case you want to have diff with the previous record. refer to this
ConnorH , What output you need. You have created date and status date with you, you can take a date diff.
new column = Datediff([created_date],[status change date],day)
In case you want to have diff with the previous record. refer to this
