date field from excel do not want to have time

[kywg33]

I have connected to an Excel table as a data source. However, in excel the data is formatted as a date (no time just date) but when it displays in my app it brings in the date but also a time of 08:00.  I do not want to have time to display, how can I do it?  Thank you very much,.

[shoog]

If the input is a datetime field, you can modify the format using the Text function, like this:

Text(Now(), "yyyy/mm/dd")

Replace Now() with the input field you have.