Forum Discussion

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

    worked like a charm

  • vjnvinod's avatar
    vjnvinod
    Impactful 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
      Impactful 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.