Using Date Picker without Time

[DanNik]

Hey Guys,

I am looking for a way to use the Day Picker without the Time function.

Just wanna set and save a Date. Do you know any approach?

greetings

[v-yamao-msft · Accepted solution]

Hi DanNik,

Could you tell us more details about your scenario?

If you want to save a Date, you could try to use Patch function.
Say I have a SharePoint list, and there is a Date column in the list, I can use Patch function to save the date to the list.
The code I am using is:
Patch(ListB,Defaults(ListB),{Title:TextInput2.Text,Date: DatePicker1.SelectedDate})

About Patch function, please check this documentation:
https://powerapps.microsoft.com/en-us/tutorials/function-patch/

And also, you could use Text function to format the Date/Time value. Please check this documentation about Text function for more details:
https://powerapps.microsoft.com/en-us/tutorials/function-text/

Please feel free reply if you need more help.

Best regards,
Mabel Mao

[tmalone]

Any idea why datepicker will log a time when i first submit a record, and yet if i go to submit another record the time is not logged? The goal here is to remove the time aspect that gets submitted the first time a record is submitted.

[akmiecik1]

What would the impact be of taking the default Date Card, deleting Hour, Minute, Error Message and Seperator, and changing the Update parameter for the card to:

Text(DateValue1.SelectedDate,"[$-en-US]mm/dd/yyyy")

[bsellers]

I did just that with one of my canvas apps and haven't had any issues.

[akmiecik1]

Hey bsellers,

It still saves to excel table with time appended.  Any thoughts?