Duration between two today date and Column date in Query Editor

[SkorpionAAM]

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 

[amitchandak]

@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 · Accepted solution]

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

now its work i used this method and its work