
Announcements
Greetings,
I am working on an app that shows all the information about an employee. All the data is created in excel and later connected to power apps. When I want to select all the fields to be shown in a form (Only view format), the fields that are in date format show the date and time (example: 9/1/2021 12:00 AM). In the view format, I only want to show the date ( 9/1/2021). I send a picture in the description. Don't know if I have to write something specific in each time card or check format in excel.
Good Day!
hi @Anonymous you can use the DateValue function e.g. DateValue(YourDateTime) and it will return as type Date. You can use the Text function e.g Text(YourDateTime,"mm/dd/yyyy") which will returm type Text.
Hope it helps