Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago
Solved

Days between dates not working

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 showi...
Need Help
Show and Tell
  • az38's avatar
    az38
    6 years ago

    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's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

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's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

az38 

 

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

Can you give me Today- anticpatedwindate

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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