web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps exclude time value fro...

Power Apps

Unanswered

exclude time value from a date value

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello I have an excel file connected to a form and a galery in my power app. I also have an add button which adds (obviously :D) values seen in the screenshot.

The problem is that it includes the time in the excel file. And somehow they date gets reduced by one day and gets the selected date - 1 day and the 22:00 or 00:00.

Does anybody know how to fix that?

Kind regards.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

NH-05081754-0 on at

Like
a
(1)

Report
Copy link

Link copied!
Try Using the DateValue() functiion.... this will convert the date pickers selected date from a Date Time Valut, to just the Date. so for example:
DateValue(DateValue1.SelectedDate)
if it is always subtracting a day, it could be a time zone/UTC conversion issue, and I'd just do a DateAdd() function around the formula above, so for example:
DateAdd(DateValue(DateValue1.SelectedDate),1,TimeUnit.Days)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, but it still includes the time. 😄

Join the conversation