Hey guys! How are you? I need help with my project, I’m developing an app that registers events with a custom number of days, who decides that is the user. The event can last for a week, or 3 days, or 2 months, and so on. I would like to know if anyone knows what I can do to extract the exact amount of days that this event has, I’m using a plugin called “Air Date/Time Picker” and I haven’t found any function that can extract dates between the initial date and the end date, not even counting how many days the event has and it is very important information for me to be able to calculate an occupancy rate for the event. Does anyone have anything to help me?
Hi there, @oalexlessa… I could be missing something, but is there a reason you can’t get the information you need by subtracting an event’s start date from its end date and format the result as days? That is a pretty standard thing to do in Bubble, but again, maybe I am missing something here.
Best…
Mike
Would I be able to get the correct result regardless of the month? I thought of this solution but I was left with a doubt, imagine if this event starts on (12/01/2022) and will only end on 02/01/2022) that is, 2 months from now, he would be able to do the calculation taking into account consideration the months too? And if I can extract it correctly, how do I do it? It’s the first time I’m working on a project with schedules, so I’m a little confused.
event end date - event start date
two fields to hold date data. ‘Event Start’ and ‘Event End’
Subtract the oldest date from the youngest date to return a positive integer of days between.
1 Like
Yup, what Doug said. Just try it… subtract the start date from the end date and format the result as days, and you will see that you get the number of days between the two dates. It really should be that simple.
1 Like
This topic was automatically closed after 70 days. New replies are no longer allowed.