Date Time Picker extract date and time separately

Hi,

I am using a date and time picker to select meeting times. However, I want to be able to save the date and time separately as well as together. However, I cannot seem to extract the date and keep it as a date (data type) so that I can perform some dynamic insert such as + days or + weeks.

Not really sure what you’re meaning that you cna’t perform +days or +weeks:
image

The value is a date object, there is no separating date and time unless you convert it to a text:
image

YOu could do the same but format as a date and then save it in a text field in your db

Thanks for the reply @paul29. I understand that date and time come as a object and cannot be separated.

If I have a date + time for example like 06/01/2024 07:10AM for a meeting. I want to send out an email 1 day prior to meeting to remind about the meeting. so if i do current time/date (which is 05/31/2024 10:00AM + 1 day, will the 06/01/2024 07:10AM be found in that 1 day or is it only 06/01/2024 10:100AM, it uses exactly 24 hours from the current time and date.

Reason is, if i have a bunch of meetings throughout the day, i want to be able to send a reminder to all of those meetings.

Yeah, if you operator includes the date range then your reminders will be triggered.

In your example date range they are within the 24 hours. But of course it will depend exactly how you specify that date range.

Dates and times are tricky, but Bubble has some nice date and time management features, so you don’t need to break them down in to separate date and time fields.

You may find this link useful for what you are trying to achieve.

I hope that helps?

Yah, as @alan8 said, it depends on your implementation.

I’m not sure exactly what you’re trying to do but I think you mean that when a user creates an event in the calendar, you want to send a reminder exactly 24 hours before that meeting? If so, then just add to the workflow when the user creates the event, an action that schedules an email to be sent 24 hours prior to the date of the event (i.e. Current event’s data +days -1)

Or are you wanting one email each day which reminds the users of all the events they have within the next 24 hours?

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.