Forum Discussion

SkorpionAAM's avatar
SkorpionAAM
Icon for Helper V rankHelper V
5 years ago
Solved

Duration between two today date and Column date in Query Editor

i m doing calcultion btween today date and columns date and used this function and getting error

 

Duration.Days(DateTime.LocalNow()-[Opreation Date])

 

 

any on can help me on this 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • SkorpionAAM's avatar
    SkorpionAAM
    5 years ago

    Duration.Days([Opreation Date]-Date.From(DateTime.LocalNow()))

     

     

    now its work i used this method and its work 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    SkorpionAAM , what is the error you are getting, the other option can be

     

    Duration.Days(DateTime.Date(DateTime.LocalNow())-[Opreation Date])

     

    Hope you are doing it power Query(M) in edit query mode

    • SkorpionAAM's avatar
      SkorpionAAM
      Icon for Helper V rankHelper V
      5 years ago

      Duration.Days([Opreation Date]-Date.From(DateTime.LocalNow()))

       

       

      now its work i used this method and its work