cancel
Showing results for
Did you mean:
Helper III

## Using If, Datevalue and Datediff

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))``

1 ACCEPTED SOLUTION
Super User

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

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Super User

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

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Announcements