schedule an email reminder one time per month

[texmexdaddy]

Hello  -  I am using one of the templated flows to send a reminder email from Outlook.    The only customization I need is to have it be sent out once per month, on the 12th of each month.   I tried adding this trigger, but when I add this, the flow never seems to work.    The odd part is that it does not show any errors, but when I check the flow history, it does not show up even though if I "test" the flow it says it ran successfully.    If I delete this trigger and do a manual test, the flow works fine.   

@equals(utcnow('DD'),string(12))

I also tried using 'MM' but that had the same result as above.    What am I missing?

[FlowHawk · Accepted solution]

Try this: @equals(utcnow('dd'), '12')

[texmexdaddy]

@FlowHawk   That small changed seemed to work!    Thank you.   Just out of curiosity, if I wanted to set the interval to let's say the 3rd Wednesday of each month, do you know how to do that?  

[FlowHawk · Accepted solution]

That is not easily done 😅 What I would do if I were in your shoes, is set the flow to trigger on every Wednesday, then set the trigger condition to check if the date 14 days ago is still in the same month as today's date, then check if the date 21 days ago is not in the same month as today's date. That would narrow to the third Wednesday.

Something like this:

@And(equals(formatDateTime(addDays(utcNow(),-14),'MM'),utcNow('MM')),not(equals(formatDateTime(addDays(utcNow(),-21),'MM'),utcNow('MM'))))

I did it to check if today was the second Monday with the following:

and(equals(formatDateTime(addDays(utcNow(),-7),'MM'),utcNow('MM')),not(equals(formatDateTime(addDays(utcNow(),-14),'MM'),utcNow('MM'))))

Which evaluated to true. I switched it to check if today was the third Monday:

and(equals(formatDateTime(addDays(utcNow(),-14),'MM'),utcNow('MM')),not(equals(formatDateTime(addDays(utcNow(),-21),'MM'),utcNow('MM'))))

Which evaluated to false. I believe that would work.

[texmexdaddy]

@FlowHawk   Thanks FlowHawk!