Calculating the number of days between two dates

[Anonymous]

I'm trying to get the number of days between two dates using a 5 digit Julian date.

# of days = DATEDIFF(Table1[Tuft JulianDate], TODAY(),DAY)

I used this and the number of days is way off. TUFTEDDATE is in the format mm/dd/yyyy. 

[jmalone · Accepted solution]

The DATEDIFF() function will only work on a column with Data Type = Date (or Date/Time). Your Julian date has a data type = Number, correct? You will need to add a column of type = Date for the function to work.