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 showing the number of days
 
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

6 Replies

  • 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

      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

    You have to change the Data Type to whole number.