Relative time in the backend

So I’m using bubble as a backend/DB for my discord bot, but was wondering if its possible to send back relative time as an api response?

What is relative time?

4 days ago, 1 months ago, etc

If you send it as text, sure. Just send Arbitrary text((Current date-time - Thing's Date:format as days:rounded to 0) days ago). If Current date-time - Thing’s date > 7 days change format as days to format as weeks, and if Current date-time - Thing’s date > 28 days change format as days to format as months or whatever.

Thanks, so to format as months, since theres no option, would I just divide the days by 30?

Yep similar to this:

On a similar theme…Is Arbitrary Date/Time dynamic i.e. if I enter ‘last week’, say for a button filter on an RG will it always show last week relative to current date/time? It doesn’t appear to. In the arbitraty field I entered ‘last week’. On my screenshot that Wed 8 Nov doesn’t change with time. Is my expression wrong?

Arbitrary dates must be in standard date/time format. To set a date to last week, set state of element to Current date/time +days -7:rounded down to week. Today is Wednesday, so this will evaluate to Monday of last week.

1 Like

Ah brilliant, many thx, understood.

One other thing I’m struggling with, I also want a button filter for ‘This Quarter’ and ‘Last quarter’ with the quarters being set at Jan-Mar, Apr-Jun etc. Any ideas how I can achieve that?

This works only when not in the first quarter:

Still trying to solve how to handle when last quarter is in the previous year. But if you need it now, this will work until January :rofl:

Okay, I believe this should be good to go for calculating the start date of the last quarter:

Similar logic would be required for the end date.

Trying to copy that but not able to get those parenthesis in…?

Enable parentheses in versions tab of the editor

1 Like