
Announcements
Good Day All,
I am using PowerApps Leave request template. The information is written into a OneDrive Excel file. I notice that when patching the StartDate into the Excel, the written date format is like: 2/23/2023 10:00:00 PM
I want to get rid of the time. I am not sure why and how this is added. I understand the code below adds it but I don't know how to set that without the time value.
StartDate: LeaveStartDatePicker.SelectedDate
@itriantafyl If you want only the Date, use the DateValue function,
DateValue(LeaveStartDatePicker.SelectedDate)
Please remember to give a 👍 and accept my solution as it will help others in the future.