Date and time help

Need help App Organization
1

Hi everyone,

I’m 12 days into my bubble journey(love it) so be gentle lol.

I’m trying to create a savings workflow so a person can lock up a certain amount and then later cash it back out with interest.

I’ve gotten the calculation set up vis a vis the amounts and the payout but the conditional for the time is killing me.

If it’s possible at all, can anyone tell me how I’d put in something like: only when one year has passed?

Thanks in advance and again sorry for what I assume is a huge noob question.

2

If it’s possible at all, can anyone tell me how I’d put in something like: only when one year has passed?

There are several ways this question can be interpreted… but I’ll take it on face-value and assume that you are actually trying (as I think you are) to use a condition (either on an element or a workflow) to only do/show something when one year has passed.

Obviously, for that to make sense, you need to have a specific moment in time defined as the point to measure from.

So, assuming you have a date field stored in the database somewhere (let’s just call it saved_date for now), then the expression is simple:

only when saved_date +(years) 1 < current date/time

3

Thank you I’d gotten almost that far in that I had the end part of that equation and didn’t know where to start it. The issue is I want the start time to be the moment the user clicks the button. It sounds like the saved date would be a fixed point in time so wouldn’t work?

4

The saved date can be whatever time you define it as.

5

If it can be set to always represent right now and not a particular date then this is perfect thank you!

6

I’m not sure I understand what you mean?

The saved date can be any time you like, but of course it has to be a fixed point in time… otherwise it doesn’t make any sense.

7

I mean it makes sense to me lol but again I’m new. I want the formula to be a set amount of time from now, now being the moment the user clicks the button. If I’m referencing a specific date like February 12th 2023 then it only works if they click the button on that day.

Maybe what I’m looking for just can’t be done idk, thanks again for your help

8

“Right now” is when you do Current date/time

So if you need to add a certain amount of time to that you can just put the +days or +years, etc afterwards and save that new date in your database

Then later check if that date is less than Current Date/time to figure out if it is expired or not

9

Thanks that’s the one!

1 Like