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 Exce...
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

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

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago

woww , it works. thanks you so much