# How to save a date with or without a time? **URL:** \ **Category:** Questions\ **Created:** [August 30, 2025, 10:19am UTC](https://forum.bubble.io/t/how-to-save-a-date-with-or-without-a-time/379768 "2025-08-30T10:19:57Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![scratch1079](https://avatars.discourse-cdn.com/v4/letter/s/50afbb/32.png) [@scratch1079](https://forum.bubble.io/u/scratch1079)\ **Post date:** [August 30, 2025, 10:19am UTC](https://forum.bubble.io/t/how-to-save-a-date-with-or-without-a-time/379768/1 "2025-08-30T10:19:57Z")
Hi, is it possible to save the date with or without a time using the time date picker?, i want to be able to create tasks that have either just a date (task can be done anytime that day), or can have the date and time set. can this be done? if so how? ---
**Author:** ![finitejest](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/finitejest/32/248088_2.png) [@finitejest](https://forum.bubble.io/u/finitejest)\ **Post date:** [August 30, 2025, 11:32am UTC](https://forum.bubble.io/t/how-to-save-a-date-with-or-without-a-time/379768/2 "2025-08-30T11:32:15Z")
We use tasks and other date related things in similar ways. There’s a couple of ways to do this. This is what we do… A few things to note: You should always store anything time related as a date or date range field. You can opt to not show the time picker in the Bubble date/time picker. You can round down dates to 12:00am. We typically have a dropdown on the ui that asks what type of task it is, and then shows fields appropriately. This also gets stored in the database just so we easily query based on type. All day things get rounded down to 12:00am before getting stored to the database. ---
**Author:** ![ramaarana7](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ramaarana7/32/250546_2.png) [@ramaarana7](https://forum.bubble.io/u/ramaarana7)\ **Post date:** [August 30, 2025, 12:43pm UTC](https://forum.bubble.io/t/how-to-save-a-date-with-or-without-a-time/379768/3 "2025-08-30T12:43:44Z")
What finitejest said is spot on. Use the “change hours to…” operator and set it to 0. This way you’ll save the date and time will be 00:00 ---
**Author:** ![boston85719](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/boston85719/32/77286_2.png) [@boston85719](https://forum.bubble.io/u/boston85719)\ **Post date:** [August 31, 2025, 3:54am UTC](https://forum.bubble.io/t/how-to-save-a-date-with-or-without-a-time/379768/4 "2025-08-31T03:54:58Z")
Dates always have time associated when saved to the database, there is no way to do it otherwise, unless you just save date as text. When working with dates, if saving from date picker with no time associated it saves as the date with time of 12:00AM, which is the start of the date. Bubble has lots of operators to extract date/time components or to manipulate. Remember that dates and time are nothing but numbers, counted usually as the number of milliseconds after or before January 1, 1970 at 12:00AM. ---
**Author:** ![scratch1079](https://avatars.discourse-cdn.com/v4/letter/s/50afbb/32.png) [@scratch1079](https://forum.bubble.io/u/scratch1079)\ **Post date:** [September 6, 2025, 7:15am UTC](https://forum.bubble.io/t/how-to-save-a-date-with-or-without-a-time/379768/5 "2025-09-06T07:15:42Z")
how would i do that? ---
**Author:** ![ramaarana7](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ramaarana7/32/250546_2.png) [@ramaarana7](https://forum.bubble.io/u/ramaarana7)\ **Post date:** [September 6, 2025, 10:00am UTC](https://forum.bubble.io/t/how-to-save-a-date-with-or-without-a-time/379768/6 "2025-09-06T10:00:44Z")
Like this ![Screenshot 2025-09-06 at 11.59.21](https://us1.discourse-cdn.com/bubble/original/3X/2/1/2104db1b61e6c7475b35e796e28ff89b4f717c21.png) Docs here: [Operators and comparisons | Bubble Docs](https://manual.bubble.io/core-resources/data/operations-and-comparisons#change-hours-to)