Forum Discussion
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
Duration.Days([Opreation Date]-Date.From(DateTime.LocalNow()))
now its work i used this method and its work
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
Duration.Days([Opreation Date]-Date.From(DateTime.LocalNow()))
now its work i used this method and its work