Is there an easy way to retrieve a Thing whose Date field is ‘less than end of the current month?’
I haven’t actually tested this, but it should be straightforward to get the first day of the next month; so anything less than that - i.e. less than 12:00am on the 1st - would include everything through the end of the current month.
I wasn’t sure how to get the first day of the next month so I’ve ended up doing this:
At time of storing Thing’s date, extract month number into a separate number field.
Then when this month number is equal to the current date/time month number, display Thing.
Probably the long way of doing this but maths is not my strong point.
This should work even in December, because the year will automatically “roll over”.
That’s your “reference date”. Anything less than that will include the current month. Of course, you can add a lower bound if need be.
EDIT: And if by this…
…you actually mean only dates within (not just “less than the end of”) the current month, then you’ll need to add a lower bound - i.e. create a date range. Thus, you’d search for dates greater than or equal to the 1st of the current month and less than the 1st of next month.
Hi Shot,
Yes that works thanks and I understand it now. I had misread the Bubble reference guide for ‘change date to’ and thought it was still adding a number instead of changing to a date.
Makes perfect sense now! Thank you so much for taking the time to respond and so clearly outline the solution. I’ll pay it forward to another Bubbler.
Jess
Get the Timex plug-in and get dates of the current month then use the < smaller sign of the item in the list
Hmmm. I feel I need to cut down on the number of plugins I use. This works as is for now.