web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Date Difference or Tic...
Power Automate
Unanswered

Date Difference or Ticks help

(0) ShareShare
ReportReport
Posted on by

I am trying to work out the difference in minutes between two dates and times, and having tried many a solution presented on here nothing seems to work...

 

When trying to use the 'Ticks' expression' I get the error that the datetime string is not valid even though as far as I can tell it is in the ISO 8601 format

 

I have included the full flow of the section I am working on below. I am assuming it is something simple but I don't work a lot with dates and I am stumped!

manderson1908_0-1696347387454.png

 

Categories:
  • Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at

    Hi,

     

    Are you sure. I've seen this before. Is the 10 the day or month? and is 3 the day or month?

    Can you get the exactly format of Time_Started and share?


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • wskinnermctc Profile Picture
    6,519 Moderator on at

    @manderson1908 I made a reference about DateDifference and Ticks in this post. DateDifference and Ticks

     

    Also it looks like there is a difference in the name "Time_Started" and "Date_Started" so just double check those to confirm.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 430

#2
11manish Profile Picture

11manish 341 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 282

Last 30 days Overall leaderboard