cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atray13
Advocate II
Advocate II

Input date only from edit form

Hi, i am trying to use power apps to update records where one of the fields is a date.

 

Using the add field option in an edit form, it pulls up a date and time picker. I only want the data to be for date. I have made the hour and minute selection not visible but when a new record is created it still inputs the default times so when looking at the source data the values are all datetimes. 

 

I have searched a lot for a solution but cannot find one that works, any ideas?

4 REPLIES 4
Pstork1
Dual Super User
Dual Super User

Date fields are actually date and time fields.  When you set them for date only there is still a time component added, but it defaults to midnight.  Just set the default time to midnight and hide the control.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
eka24
Community Champion
Community Champion

Change the format of the date example:

date.JPG

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Is there no way to not include the time? If i were to input just the date directly into excel it would show up as date only.

But if you read a data only column from Excel you will find that it has an implied time unless you format it as a date only value.  Date fields in Excel are stored as the number of milliseconds after a particular point in history, so they always include a time value.  For a Date only field it just isn't displayed but its there.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,287)