Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago
Solved

Calculate between 2 dates

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 

Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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