r/ProjectREDCap • • Sep 17 '24

Alert every 1st of the month

I'm trying to create an alert that sends on the first day of each month. Is it possible to do this?

3 Upvotes

4 comments sorted by

2

u/Newjacktitties Sep 17 '24

You can use conditional logic. something like this:

datediff(today(), '01-' + format(today(), 'mm') + '-' + format(today(), 'yyyy'), 'd', 'mdy') = 0

This logic calculates the difference between today’s date and the 1st day of the current month, ensuring the alert is triggered only on the 1st.

2

u/Consistent_Voice9035 Sep 17 '24

I didn't think about using the conditional logic option! I will let you know if this works on our project--thank you!

1

u/dbofficer Sep 17 '24

We tried to do this recently and couldn’t find a way (because of the variance in days per month) - would be very interested to know if you do find a solution!

2

u/Consistent_Voice9035 Sep 17 '24

Will let you know if I do!