Hey friends, has anybody built logic that tracks consecutive days? Basically, I’m trying to think through the logic that says: If this was updated yesterday, add 1. If not, reset to 1.
I’ve tried a number of things, but Bubble’s expression editor won’t let me do date calculations in the “Only When” step of the workflow blocks. Any ideas?
Hey @andrewgassen,
Would this work?
Only when Current Date/time +(days) -1 :formatted as m/dd/yy is SomeDateValue :formatted as m/dd/yy
Let me turn
into
Coaching and Development at https://uniqueideas.com or schedule a free intro session 
Ken Truesdale
LinkedIn
That’s what I was trying to do, but the expression composer wouldn’t let me construct that example. I’ll refresh and try again, in case it’s some weird editor issue.
I only tried with a search lookup:
Hmm, interesting. Looks like I needed to use the “formatted as” or else it wouldn’t work. Thanks for the solution!
Ya, without the formatted as, you’d be comparing the entire date/time values, rather than just the date alone.
