Unanswered

Ticks function is unable to compare the dates

(0) Share

Report

Posted on by Sajith

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.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Sajith

Please post a copy of your Flow.

Was this reply helpful? Yes No
Sajith 182 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sajith 182 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No