Date/TIme variance based on day only (ignoring time)

[Anonymous]

I have got two date/time fields in the table that I am using in a nested if statement that calculates the variance between them. I want power bi to ignore the hours completely and calculate the variance based on days only

Example:

What I get : (01/01/2020 00:00:00) -( 01/01/2020 17:00:00) =  1

What I would like to see  (01/01/2020 00:00:00) -( 01/01/2020 17:00:00) =   0 ( because the day is the same) 

Formula extract:

VAR = IF(ISBLANK(tasks[TaskFinishDate]), 9999,

IF(tasks[DEP TYPE1]="GIVE",(tasks[ Forecast 9th Mar]- tasks[TaskFinishDate]),

 8888))

Thank you 

[Anonymous]

The best way is to store date and time separately. Then you won't have such problems.

Best
D

[Greg_Deckler · Accepted solution]

Use INT([datetime])

This will drop the decimal portion of your date time column.

[Anonymous]

@Greg_Deckler  Thank you very much, one last question is there a way to apply INT per formula rather than per each date column ( as my formula has quite a few lines) ?  

so that instead of INT(date1)-INT(date2)

something like INT([date1]-[date2]) - this didnt work but wondering if there is a way to do this ?

Thank you

[Greg_Deckler]

Might be able to use TRUNC