Power Platform Community Forum Thread Details

Hello,

I built a flow for comparing my "Eintrittsdatum" in Excel with todays date. I tried it by building 2 variables and comparing them.

The problem is, even if my variables are the same date, the condition always say it's "false" and I do not know, where the problem is.

Flow 1.png

compose eintrittsdatum.png

I used this for my compose for the "Eintrittsdatum":

addSeconds('1899-12-30 00:00:00',int(formatNumber(mul(float(items('Apply_to_each')?['Eintrittsdatum']),86400),'0','en-us')),'yyyy-MM-dd')

flow 2.png

and this for todays date:

formatDateTime(utcNow(), 'yyyy-MM-dd')

In my condition I tried to compare the two variables, but its always false:

flow 3 condition.png

Output when I look into the variables after run:

output Tagesdatum.png

output Eintrittsdatum.png

Does anyone know, what I do false here?

Thank you.

Categories:

Compare Excel-date with today - Condition always "false"