Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
10 years ago
Solved

DATEDIFF

I keep getting errors with Date Diff.  I need to find hours difference between Open Date and Resolved Date.

 

Each item does not have a Resolve Date, so I tried

 

"Resolution Time= IF('table'[Resolved Date] <> BLANK(), DATEDIFF('table'[Open Date], 'table'[Resolved Date], HOUR), 0)"

 

But still get errors.

Need Help
  • Sean's avatar
    Sean
    10 years ago

    bhmiller89 Try this formula as a column...

     

    Resolution Time Column = 
IF (
    ISBLANK ( 'Table'[Resolved Date] ),
    0,
    IF (
        'Table'[Resolved Date] < 'Table'[Open Date],
        -1 * DATEDIFF ( 'Table'[Resolved Date], 'Table'[Open Date], HOUR ),
        DATEDIFF ( 'Table'[Open Date], 'Table'[Resolved Date], HOUR )
    )
)

    If this works you have some resolved dates that are prior to their respective open date.

    Those will appear as negative numbers in the resolution column because of the * -1.

    Hope this resolves the errors! :smileyhappy:

     

1 Reply

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    bhmiller89 Try this formula as a column...

     

    Resolution Time Column = 
IF (
    ISBLANK ( 'Table'[Resolved Date] ),
    0,
    IF (
        'Table'[Resolved Date] < 'Table'[Open Date],
        -1 * DATEDIFF ( 'Table'[Resolved Date], 'Table'[Open Date], HOUR ),
        DATEDIFF ( 'Table'[Open Date], 'Table'[Resolved Date], HOUR )
    )
)

    If this works you have some resolved dates that are prior to their respective open date.

    Those will appear as negative numbers in the resolution column because of the * -1.

    Hope this resolves the errors! :smileyhappy: