Forum Discussion
Solved
Calc difference between two dates in days
Hello, I've been striking out on what I believe is something simple. I have two date fields in my table. They are both formatted as a date. I want to create a column that shows the #days difference ...
Create a new column and then use datediff
Column 1 = DATEDIFF('main table'[Date Completed],'main table'[Date Received],Day)
amitchandak
Super User
Super UserCreate a new column and then use datediff
Column 1 = DATEDIFF('main table'[Date Completed],'main table'[Date Received],Day)