Skip to main content
Solved

How Can I Set Reminders on Specific Days Once a Month?

  • November 11, 2025
  • 1 reply
  • 21 views
D
Forum|alt.badge.img+2

I have an automation that reminds me to complete a task once every month, however, I realized what I actually need is a reminder specifically on the second Wednesday of every month. I’ve been having a lot of trouble figuring out an automation for this new reminder requirement and would love some assistance if anyone has any tips or advice.

Best answer by VikasVimal

Oooh! 
Dates and Days are tricky. Simpler to stick with 10th of the month like schema.

Here’s a tip regardless:

IF(
  {Date},
  DATEADD(
    DATETIME_PARSE(DATETIME_FORMAT({Date}, 'YYYY-MM-01'), 'YYYY-MM-DD'),
    MOD(
      3 - WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Date}, 'YYYY-MM-01'), 'YYYY-MM-DD')) + 7,
      7
    ) + 7,
    'days'
  )
)

 This will give you the 2nd wednesday of the current month. compare it to today() and use it to trigger an automation.

You can’t do it in Automation alone.

1 reply

VikasVimal
Forum|alt.badge.img+12
  • VikasVimal
  • Inspiring
  • 50 replies
  • Answer
  • November 12, 2025

Oooh! 
Dates and Days are tricky. Simpler to stick with 10th of the month like schema.

Here’s a tip regardless:

IF(
  {Date},
  DATEADD(
    DATETIME_PARSE(DATETIME_FORMAT({Date}, 'YYYY-MM-01'), 'YYYY-MM-DD'),
    MOD(
      3 - WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Date}, 'YYYY-MM-01'), 'YYYY-MM-DD')) + 7,
      7
    ) + 7,
    'days'
  )
)

 This will give you the 2nd wednesday of the current month. compare it to today() and use it to trigger an automation.

You can’t do it in Automation alone.


Terms & ConditionsAccessibility statement