Using If, Datevalue and Datediff

[DRossi]

Hello,

I am trying to calculate the deifference between two dates only. If the date in one column is 01 January 1900 then leave then do nothing or return blank, if it is not 01 January 1900 then do the date diff calc and return the amount of days difference. I;ve tried different combinations but can't get it to work.

Days to Close1 = IF(DATEVALUE('Job Dates LH'[LH_Job_Completed_Date])= "01 January 1990", BLANK(), DATEDIFF('Job Dates LH'[LH_Job_Completed_Date],'Job Dates LH'[LH_Job_Opened_Date],DAY))

[Samarth_18 · Accepted solution]

Hi @DRossi ,

Try this:-

Days to Close1 =
IF (
    DATEVALUE ( 'Job Dates LH'[LH_Job_Completed_Date] ) = DATE ( 1990, 01, 01 ),
    BLANK (),
    DATEDIFF (
        'Job Dates LH'[LH_Job_Completed_Date],
        'Job Dates LH'[LH_Job_Opened_Date],
        DAY
    )
)

Thanks,

Samarth