Hello
Not sure I'm doing this the best way, but I'm using a single record (single field) table to store the last refresh date of a data set and I want to show this in my app. However, I cannot get Search, Lookup, Last, First, LastN, FirstN to work when there is only one record in the table. If I add a second record no problem.
Has anyone else found this and is there a work around.
I'm using an excel spreadsheet in OneDrive as the datasource and these formulas work with two rows of data but not with one:
First(tblLastRunDate).DateLastRun
LookUp(tblLastRunDate,DateLastRun<Today()+100,DateLastRun)
brian