web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to set condition t...

Power Automate

Answered

How to set condition to compare dynamic date with a fixed date?

(0) Share

Report

Report

Posted on by Community Power Pla...

Hello

I have a column of dates from Excel online in the following format:

25/12/2021
31/12/2021

31/12/2021

02/01/2022
09/01/2022

26/01/2022

I want to build Flow with a condition that will show only the dates as from 03/01/2022.

Here is my attempt:

ticks(addDays('1899-12-30',int(items('Apply_to_each_-_in_table_Forms_Data')?['End date']), 'yyyy-MM-dd'))

is greater than or equal to

ticks('2022-01-03'))

But it gives an error! Any help would be much appreciated!!

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

VictorIvanidze 13,073 on at

Like (0)

Report

Hello,
see https://manueltgomes.com/reference/powerautomate-function-reference/power-automate-ticks-function/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
It is quite confusing. I used the formula:

add(div(sub(ticks(2022-01-03),ticks('1900-01-01T00:00:00Z')),864000000000),1)

But i get an error! Should i change both conditions or just the fixed date? I tried both and it is not working.
In my first formula, it states 1899-12-30 but in your suggested website, it uses 1900-01-01. That might be causing issues??

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous :

Please put quotes around the date and try again:

add(div(sub(ticks(’2022-01-03‘),ticks('1900-01-01T00:00:00Z')),864000000000),1)

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation