Days between dates not working

[vjnvinod]

hi

Below is what my formula for calculating days

days = 'Pipeline Extract'[AnticipatedWinDate] -(TODAY())

 and i am getting output like below, not sure whats wrong

i was expecting a output showing the number of days

[az38 · Accepted solution]

Hi @vjnvinod 

also you could try DATEDIFF() function

Column = DATEDIFF('Pipeline Extract'[AnticipatedWinDate],TODAY(),DAY)

do not hesitate to give a kudo to useful posts and mark solutions as solution

[vjnvinod]

@az38 

sorry, i thought it worked but, its giving me wrong output, i have used below and see what it is doing

AWD_Days = DATEDIFF('Pipeline Extract'[AnticipatedWinDate],TODAY(),DAY)

[vjnvinod]

@az38 

Actually if we can reverse this, it will give me the right output

Can you give me Today- anticpatedwindate

[Anonymous]

Just do this. No need for DateDiff in this scenario. + Numbers are in the future, - in the past. 

[vjnvinod]

worked like a charm

[Anonymous]

You have to change the Data Type to whole number.