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

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
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.