# Extract from date/time

**URL:** <https://forum.bubble.io/t/extract-from-date-time/276887>\
**Category:** Questions\
**Created:** [August 8, 2023, 10:01pm UTC](https://forum.bubble.io/t/extract-from-date-time/276887 "2023-08-08T22:01:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![phillip.hunter](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/phillip.hunter/32/183510_2.png) [@phillip.hunter](https://forum.bubble.io/u/phillip.hunter)\
**Post date:** [August 8, 2023, 10:01pm UTC](https://forum.bubble.io/t/extract-from-date-time/276887/1 "2023-08-08T22:01:50Z")

</div>

Hi all. I’m using the standard date/time picker to allow the user to set a date. The input form is set to Input type: Date. This returns “August 29, 2023 12:00 am” I want to display just “August 29, 2023” however displaying the full value shows the time, too, and using the :extract… operator returns isolated integers.

How can I get the result of “August 29, 2023”?

Thank you!

---

<div class="post-metadata">

**Author:** ![tylerboodman](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/tylerboodman/32/242142_2.png) [@tylerboodman](https://forum.bubble.io/u/tylerboodman)\
**Post date:** [August 8, 2023, 10:07pm UTC](https://forum.bubble.io/t/extract-from-date-time/276887/2 "2023-08-08T22:07:21Z")

</div>

`[date]:format as 8/8/2023`  
Then it lets you do the preset formats or make your own

---

<div class="post-metadata">

**Author:** ![phillip.hunter](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/phillip.hunter/32/183510_2.png) [@phillip.hunter](https://forum.bubble.io/u/phillip.hunter)\
**Post date:** [August 8, 2023, 10:13pm UTC](https://forum.bubble.io/t/extract-from-date-time/276887/5 "2023-08-08T22:13:04Z")

</div>

Ah, I see it now. More options in :format as. Thank you!
