Unanswered

utcNow equal to failing

(0) Share

Report

Posted on by JLCPA_IT

Good morning,

I'm trying to build a flow that checks utcNow for 'MM' and, separately 'dd' to effectively create a flow that will trigger on the 1st day of a given month. The issue I'm running into is that while I can get the right output for MM and dd, my condition that checks "is equal to" always returns false. Any help on why it's showing up like this is much appreciated. Screenshots below:

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

LeeHarris 1,026 on at

Like (0)

Report
Copy link

Link copied!

Hi @JLCPA_IT

Try removing the quotes around the numbers in your condition so '11' becomes 11 and see if that works.

Was this reply helpful? Yes No
JLCPA_IT 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @LeeHarris,

Just tried it and still the same problem.

Was this reply helpful? Yes No
LeeHarris 1,026 on at

Like (0)

Report
Copy link

Link copied!

Hi @JLCPA_IT

I have just tested this and managed to get it to work by changing the compose step to

int(utcNow('MM')) and the condition to not use quotes. With both these changes the condition was true. See if that works in your scenario.

Was this reply helpful? Yes No
Pstork1 69,018 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Try the following formulas instead. For the day calculation use

dayOfMonth(utcNow())

and for the Month switch to using the three letter abbreviation

formatDateTime(utcNow(),'MMM')

That worked for me.

Was this reply helpful? Yes No
JLCPA_IT 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks @LeeHarris. It did work for just one month, but once I expand to an "or" condition, it now ends up with true...

Was this reply helpful? Yes No
JLCPA_IT 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the suggestion @Pstork1. Are the 3 letter abbreviations listed somewhere so I can check those?

Specifically looking at February, May, August, and November, which I assume are Feb, May, Aug, Nov?

Was this reply helpful? Yes No
Pstork1 69,018 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Those would be the abbreviations.

Was this reply helpful? Yes No