# Need help with Date/Time picker Format

**URL:** <https://forum.bubble.io/t/need-help-with-date-time-picker-format/213870>\
**Category:** Need help\
**Created:** [July 3, 2022, 9:20am UTC](https://forum.bubble.io/t/need-help-with-date-time-picker-format/213870 "2022-07-03T09:20:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![junaid.cordis](https://avatars.discourse-cdn.com/v4/letter/j/97f17d/32.png) [@junaid.cordis](https://forum.bubble.io/u/junaid.cordis)\
**Post date:** [July 3, 2022, 9:20am UTC](https://forum.bubble.io/t/need-help-with-date-time-picker-format/213870/1 "2022-07-03T09:20:52Z")

</div>

Hi,  
I’m trying to apply date format on simple date/time picker but I don’t know what I’m doing wrong applying format is working ok but when I’m saving this date value in database its not in the format which I applied, I need to save it in same format I applied

 ![Screenshot 2022-07-03 141058](https://us1.discourse-cdn.com/bubble/original/3X/8/6/8664e14cbaaaf078060bc049990c08407d0e729d.png)  
 ![Screenshot 2022-07-03 141209](https://us1.discourse-cdn.com/bubble/original/3X/b/2/b2407fcc450d1dadcce5209261882f43d354c1ba.png)

---

<div class="post-metadata">

**Author:** ![lregefalk](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/lregefalk/32/175879_2.png) [@lregefalk](https://forum.bubble.io/u/lregefalk)\
**Post date:** [July 3, 2022, 9:54am UTC](https://forum.bubble.io/t/need-help-with-date-time-picker-format/213870/2 "2022-07-03T09:54:42Z")

</div>

Hello! It’s saved in the correct format, even though the preview displays it as “Jul 3, 2022 2:09 pm”. Click on the pen icon and you can see the actual database entry, which will be formatted “07/03/2022 12:00 am”

Hope this helps 🙂

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [July 3, 2022, 9:55am UTC](https://forum.bubble.io/t/need-help-with-date-time-picker-format/213870/3 "2022-07-03T09:55:56Z")

</div>

A date value is a time stamp… formatting is soemthing you do with that time stamp when you want to display it somewhere (or convert it into a text)…

So if you want to store the actual date value as a date then you can’t apply any formatting to it (that wouldn’t make sense)…

You apply formatting to a date when you want to display it (i.e. on the page)

Unless (for some reason) you want to save the date as a text in your database, in which case you can apply formatting to the date/time picker’s value to change it into a text (note: the format field in the date picker element is just for the way the date displays on the element - if you want to save the date as a text then you’ll need to apply formatting to the actual value).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [September 11, 2022, 9:21am UTC](https://forum.bubble.io/t/need-help-with-date-time-picker-format/213870/4 "2022-09-11T09:21:37Z")

</div>

Closed on September 11, 2022, 9:21am UTC

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