One caveat as I haven’t tested this but I just saw that Hubspot is looking for the timestamp to be midnight UTC. I am fairly certain Bubble stores dates in UTC (so the above formula should work) but if not you may have to add a +hours to the formula above to adjust from user’s current timezone to UTC.
Here’s a forum discussion that goes into some depth on that