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?
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.
Change the format of the date example:
------------
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.
User | Count |
---|---|
122 | |
86 | |
83 | |
74 | |
69 |
User | Count |
---|---|
215 | |
179 | |
140 | |
108 | |
83 |