Calculate between 2 dates

[Chanleakna123]

HI , 

Good day to you. 

I tried multiples on Calculation between 2 dates by this calculation Diff= 1.*([Last Date]-[First Date]) . The output shown different number which i type manual on Excel for 6 to 7 days. 
I'm wondering , what wrong with the data ? while i verify again and again. still foundd nothing wrong on the originated data. 

Thanks with regards 
Chanleakna Hang 

[v-yulgu-msft · Accepted solution]

Hi @Chanleakna123,

Are you aimed to create a measure or calculated column using this formula Diff= 1.*([Last Date]-[First Date])? 

If it is the latter and [Last Date] and [First Date] are both column fields, this formula is correct. It can return expected results.

Otherwise, you should use DateDiff function to return date interval between two dates in a measure:

Diff = DATEDIFF([First Date],[LastDate],DAY)

Best regards,
Yuliana Gu

[Chanleakna123]

woww , it works. thanks you so much