In my flow, I need to check whether a record's date month and day match a specific date but not the year.

So, I have a basic decision item that looks like this:
{!Record.StartDate} = DateVariable

I thought I'd define a variable in which I could use DATE(year,month,day), but I'd need to replace year with a wildcard, which I can't find whether it's even possible.

How would you go about it?

Thanks for your help!

1 Answer 1


Instead of a single Date variable you need two separate constants for the day of month and month you want to match.

You can then use the DAY and MONTH formula functions to extract the day and month values from your record's start date for testing in your condition, like:

DAY({!Record.StartDate}) = 1 &&
  MONTH({!Record.StartDate}) = 4

If the start date is a Datetime, not a Date, you will want to use DATEVALUE to get the date to pass to each of these functions. Note that flow formulae operate on UTC date/time values.

  • Beautiful and so much more logical indeed! Thank you!
    – Sebbie
    Feb 22, 2023 at 8:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .