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)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Sajith

Please post a copy of your Flow.

Was this reply helpful? Yes No
Sajith 182 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No