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... Microsoft Employee

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:

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
see https://manueltgomes.com/reference/powerautomate-function-reference/power-automate-ticks-function/
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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??
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Join the conversation