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?

Yep similar to this: [image] Date format like Facebook Need help You’ll need to have some different conditions on your text element depending on how long ago the date was. Each condition having a range that the time would fall between with the appropriate text shown. Make …

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…

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

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. I…

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.

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: [CleanShot 2023-11-15 at 18.38.30@2x] 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: [CleanShot 2023-11-15 at 18.51.57@2x] [image] Bubble Editor - nquforumdemo Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Inst…

Relative time in the backend

Need help APIs

tylerboodman August 5, 2023, 12:56am 6

Yep similar to this:

Topic		Replies	Views
Convert date-time returned from back-end workflow to relative time APIs	1	177	June 4, 2024
How does the bubble forum reformat dates per this screenshot? Database	13	758	September 17, 2020
New Plugin: Relative Time with Moment.js Showcase	84	10738	March 4, 2025
Date format like Facebook Need help	2	624	July 11, 2023
How to display upcoming date by {"Yesterday" "Today" "Tomorrow" "In (1-31) days" "In (1-12) months" Need help	3	1382	July 1, 2022

Relative time in the backend

Related topics