mikeloc
February 6, 2021, 10:24am
8
For what it’s worth, I found this thread that might be of interest to you…
Hi everyone! I’ve been looking without success for a solution to what seems like a really simple problem.
Let’s say I want to send an email to a user on their birthday.
The user’s birthday is stored using a simple date input field (as true date/number, not formatted as a text).
I want to send an email every year, on the user’s birthday. For example: if a user’s birthday is 10/12/88, I want to send an email on 10/12 every year.
When I try and use a recurring event, and go to select the date i…
The “extract” route that I mentioned is brought up in that thread, too, and this particular response is why I suggested saving the month and date to separate fields…
Thank you!! Just tested this, and it worked for conditional formating. I had been playing with :extract for a while, but didn’t understand putting the date and month back to back as you suggested.
However, it doesn’t appear to work this way in workflows. For example, if I try to set a recurring event, it asks for the date to begin it on. I can’t find a way of inputting the equivalent of 10/16 that it will “accept”, and I can’t seem to use :extract to make it work either.
Anyway, that’s enough out of me in this thread for sure.
Best…
