Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Alice08
Helper II
Helper II

How to calculate difference between two dates

Alice08_0-1713445673726.png

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

can someone plese guide here?

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
Alice08
Helper II
Helper II

Alice08_0-1713460835568.png

Thanks it worked

PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.