Answered

Remove time from a datetime value

(1) Share

Report

Posted on by EP3

Hi, I have a date picker, I want to take the date from that and add a time string to to to make a datetime. 1st attempt looked something like this:

Datetimevalue(datePicker1.selectedDate && " 15:00")

But with this I get an error as the datepicker date is actually a datetime with the time component being "00:00". I tried datevalue(datepicker1.selectedDate) but no change. I know I can do something like "Text(Left(datePicker1.selectedDate,Len(datePicker1.selectedDate)-5))to remove the "00:00", but I feel like I must be missing the intended way of doing it, as it seems like adding a time to a date from a date picker is something that would happen a lot and there'd be a more elegant way of achieving it. Any thoughts? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@EP3

I get no error using
DateValue(DatePicker1.SelectedDate)
When putting this in Text property of a Label I get just the Date.
Note, I also get just the date when using
DatePicker1.SelectedDate

The following variations also all work for me:
DateValue(DateTimeValue(DatePicker1.SelectedDate))
and
DateValue(Text(DateTimeValue(DatePicker1.SelectedDate)))
Even if my Date Picker Format is set to DateTimeFormat.LongDateTime
All of the above still works for me.

Perhaps you have more information of the issue? I could not reproduce it.

Was this reply helpful? Yes No
EP3 73 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks very much for checking that so quickly, I'm not at a computer right now but I'm thinking now that I've probably missed something in the date picker settings... I'll update or accept when I get to check it tomorrow. Thanks again!

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@EP3

My inclination is to define a new DateTime like so. I prefer to avoid techniques that convert text representations of datetimes due to problems that can arise when running apps on devices with different regional settings.

With({dte:datePicker1.selectedDate}, DateTime(Year(dte),Month(dte),Day(dte),15,0,0) )

Was this reply helpful? Yes No
EP3 73 on at

Like
a
(0)

Report
Copy link

Link copied!

Turns out I'd forgotten that I was actually selecting from a label within a gallery, the date in the label was constructed using DateAdd within a sequence to allow the display of x days after the selected date. Anyway. I selected this answer as it makes a great point about the issues of timezones that I hadn't considered and seems like best practice and it did the job. Thanks!

Was this reply helpful? Yes No