You're welcome! If there's any topic you'd like me to go more in-depth on, let me know!
@rodrigoleyva2297Ай бұрын
Very helpful buddy, thnks
@RotiveАй бұрын
You're welcome!
@OyaBuyukcelenАй бұрын
Hİ. How can I make it work on the first Monday of every month?
@mchan9424 Жыл бұрын
Video is totally worth it!
@Rotive Жыл бұрын
Thank you! Glad you found it valuable.
@dangramit9 ай бұрын
Terrific - thank you Brian
@Rotive8 ай бұрын
Thanks, Dan!
@terrycole Жыл бұрын
Nice!
@zenubio018 ай бұрын
Plot twist, how do you get it to only run on the last day of the month? For example if your decision node says Day of Month => 28. It's going to run on March 29th because that statement is true, but I don't want it run until the 30th. For my use case, I was just able to look for overdue records and tell it to just run on the first of the month, but thought this might be an interesting challenge. Love your videos Brian, keep it up!
@juliebaxterneeatkin25718 ай бұрын
Hi - I created another formula for 'Month of year' to display 1 to 12, then included that in the decision criteria. If Day of month = 31 and Month of year is 1, 3, 5, 7, 8, 10, 12 If Day of Month = 30 and Month of year is 4, 6, 9, 11 If Day of Month = 28 and Month of year is 2 It may be better to do all that as part of a formula checkbox though, ('today is last day of month) then put the checkbox formula as the decision criteria 'if today is last day of month is true'.
@Rotive8 ай бұрын
Love this question. Julie's formula looks good to me, but I'd try and simplify it by looking at tomorrow's date. TODAY() + 1 will give you tomorrow's date, then you can wrap that in the DAY() function to return the day of the month for tomorrow. If tomorrow's day of the month = 1, then you know today is the last day of the month. Should work on leap years too.
@juliebaxterneeatkin25718 ай бұрын
@@Rotive Fabulous! I am going to change my formula!