Answered

Datepicker remove time stamp in excel and keep only date?

(0) Share

Report

Posted on by Madiko

I have PowerApps form, where I set deadlines and etc. My Datasource is excel spreadsheet. When I submit form, it records to excel with date and time in this format: 2021-08-31T04:00:00.000Z. However, I don't need time stamp. How can I remove time and keep only date in excel? Initially datepicker in the form was with time, but I removed it from the form (hours and minutes).

In my datacard where datepicker located there is a function: UPDATE. What I have under this function: DateValue1.SelectedDate

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Madiko 37 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni can you help?
Madiko 37 on at

Like
a
(0)

Report
Copy link

Link copied!

this is what I had in my form with time:
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Madiko ,

Please try and modify Update of the data card to:

Text(DateValue1.SelectedDate,"dd-mm-yyyy")

"dd-mm-yyyy" is the date format.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Madiko 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Jeff, but it didn't help. I still have the same result.
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Madiko ,

What is the column format? Using Date type column would cause this issue sometimes, please try and modify the column type to the General type.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Verified answer

Madiko 37 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks, it didn't help with existing column. However I found a solution. I created another datepicker and created another column in excel as text.