Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Ticks function is unable to compare the dates

(0) ShareShare
ReportReport
Posted on by 182

I have Created Date and Completed Date for comparison. These dates from the SharePoint List is stored in variables. Because it is not accessible inside Do Until Loop. Hence Ticks function is not comparing properly.

 

For example, Created Date is assigned to a string variable and using ticks function 

ticks(formatDateTime(variables('createdDate'),'MM/dd/yyyy')) compared to the Completed Date using same tick function. However it is not working as expected. 

 

  • Sajith Profile Picture
    Sajith 182 on at
    Re: Ticks function is unable to compare the dates

    Infact Created Date is not available. Hence assigned to a variable.

     

    ticks-issue.jpg

     

    2022-07-20_12-32-31.jpg

  • Sajith Profile Picture
    Sajith 182 on at
    Re: Ticks function is unable to compare the dates

    Created and Completed Dates are same day. No Time is considered. 

    Created is assigned to a variable called formatCreated and set it to -  formatDateTime(Created),'MM-dd-yyyy') or formatDateTime(Created),'MM/dd/yyyy')

     

    . Then used the function ticks for comparison

    ticks(formatCreated) is greater than ticks(formatCompleted). However the Do Until Loop goes inside.

     

     

     

    ticks-issue.jpg

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Ticks function is unable to compare the dates

    @Sajith 

    Please post a copy of your Flow.

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard