# How to set only date not time on set values
**URL:** https://community.glideapps.com/t/how-to-set-only-date-not-time-on-set-values/48405
**Category:** Ask for Help
**Created:** [September 2, 2022, 12:11pm UTC](https://community.glideapps.com/t/how-to-set-only-date-not-time-on-set-values/48405 "2022-09-02T12:11:42Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Madhav\_yagni](https://community.glideapps.com/u/Madhav_yagni)
#### Post date: [September 2, 2022, 12:11pm UTC](https://community.glideapps.com/t/how-to-set-only-date-not-time-on-set-values/48405/1 "2022-09-02T12:11:42Z")
I am trying to set only date but there I only see is current date/time I only want date
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 2, 2022, 1:42pm UTC](https://community.glideapps.com/t/how-to-set-only-date-not-time-on-set-values/48405/2 "2022-09-02T13:42:06Z")
How are you setting it? Are you using a Date/Time component? Have you tried the Date component?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 3, 2022, 12:32am UTC](https://community.glideapps.com/t/how-to-set-only-date-not-time-on-set-values/48405/3 "2022-09-03T00:32:50Z")
What Jeff was referring to is a “date picker”, opposed to the “date-time picker”, which does include the time.
> **[Date Component](https://www.glideapps.com/docs/reference/app-components/date-picker)**
>
> Pick a date.
If you mean you want to set a special value to a column as only “date”, you can set it using the “current date/time” option, then format the destination column to show only “date”.
---
### Author:  [@Felix\_Bachle](https://community.glideapps.com/u/Felix_Bachle)
#### Post date: [September 13, 2023, 2:55pm UTC](https://community.glideapps.com/t/how-to-set-only-date-not-time-on-set-values/48405/4 "2023-09-13T14:55:47Z")
Hi all,
I do have a similar topics, I am struggling with.
I have a simple table with an “Add” button to enable users to add another row to the database.
When the User clicks the button, the overlay with the input fields opens.
One of the fields is for date of birth. In the database, the field has the date only format. However, when I choose the field and design in the frontend, I only can choose the date & time design.
How can I choose the “date only” design also in the frontend, so the user is not required to insert the time of their birth? 🙂
Many thanks in advance!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 13, 2023, 3:01pm UTC](https://community.glideapps.com/t/how-to-set-only-date-not-time-on-set-values/48405/5 "2023-09-13T15:01:22Z")
Use a Date picker instead of a Date Time picker.
