How to calculate difference between two dates

[Alice08]

i want to calculate difference between created date and current UTC time, but its giving error.

can someone plese guide here?

[Alice08]

Thanks it worked

[PhilipTreacy · Accepted solution]

Hi @Alice08 

You haven't said what the error is so I'm guessing as to what is in your Createddate column.

Also you say you want to calculate the difference between a time and date.  I presume you mean the difference between two dates as you are looking for the Duration.Days

Try this

= Duration.Days(DateTime.Date( DateTime.LocalNow())  - [CreatedDate])

Regards

Phil