News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows How to set condition t...

Power Automate - Building Flows

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!!

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

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

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
Community Power Pla... on at

Like (0)

Report
Re: How to set condition to compare dynamic date with a fixed date?

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??
VictorIvanidze 12,530 on at

Like (0)

Report

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

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans