I have an app when a new record is created it grabs the date and time and store in Excel Spreadsheet which is my data source. I present that date and time as a number which correlates to that record and is displayed in the app. I want the user to be able to search by the date format of yyyymmddhhmmss. Even if I change the format to that in the spreadsheet, I still cannot search for that in the search box. I uploaded a word document with screenshots of app to better explain what I am trying to do.

Report
All responses (
Answers (