I was hoping I could schedule a post for the that exact date and time and show the contents but it won’t.
Once I had that working, my plan was to get the ‘now’ (date and time) from Integromat and add 15 minutes so it would check the rows for any thing scheduled for the next 15 minutes before Integromat makes the next check in 15 minutes time
Could you please share the link to the post where I gave the original solution? I don’t remember the details off the top of my head, and I don’t use Integromat that actively any more, so I’m a little fuzzy on where to go without comparing against what I wrote originally.
Sorry that I didn’t check back sooner. My schedule doesn’t leave me with a lot of time to visit this forum.
One thing that I notice is that you added separators to the formula. In my original, I didn’t include slashes between the segments; e.g. DDMMYYYY vs DD/MM/YYYY. I’m not sure if removing the separators will really change anything, but it’s something that caught my eye. In the end, it’s all about the string comparison, so as long as the strings match formats, the presence or absence of separators shouldn’t matter.
Your use of Integromat’s addMinutes function is incorrect. The addMinutes function takes the starting time as the first argument before the semicolon. That second formula should be this:
Even with that fixed, though, that won’t give you all matching entries within the next 15 minutes. It would only give you entries that are exactly 15 minutes from the current time. Finding entries that fall within a range of time would be a much more complex formula.
Before working on that time range issue, though, let’s first nail down why the exact match isn’t working. Would you please share a screenshot of your actual Integromat scenario setup where that first formula is being used? Something tells me that might shed some light on things. Also, would you please share more details about your use case and what you’re trying to accomplish? All that I can tell right now is that you’re trying to schedule posts. There may be other ways to pull this off, but knowing your end goal would be helpful.