What is the best app formula to calculate number of days past since new row was added?
How about NOW() - MAX(TableName[DateTime])
Thanks for the insight.
Looks like I’m closer… The spreadsheet displays decimal days, which is fine.
The app displays what appears to be hours:min:sec.
-neither the spreadsheet or the app update as the duration extends. How to get current days displayed in app? -how do I force the app to display days rather than time?
I’m new to the MAX function.
Looks like used to determine highest value in an array.
Just to be clear, I am attempting to display the duration of days for each individual row.
With this in mind, does the MAX function still apply?
Need to display the elapsed time between when the row was created and NOW.
Thanks for your time!
Ok making more progress with one more snag… =HOUR(NOW() - [Date])//24 + MINUTE(NOW()-[Date])/1440.00
Minimized your formula and the ‘time duration’ is changing as it should be BUT only in the slice view _Form of my app.
Not sure why the slice view _Detail ‘time duration’ is locked along with the slice view _Table.
Any suggestion on why the different view types don’t display the correct ‘time duration’?
Also, note that after sync the app the excel spreadsheet located in BOX is not updating either.
Okay… I misunderstood your request slightly. I thought you want to compare between the last record of your table and now.
When you want to show it dynamically, you need to use it with the virtual column. If you want to calculate with date only, you could write it like… HOUR(TODAY() - [Date])/24
Sorry about the confusion.
The ‘time duration’ displayed in view _Form worked perfectly over night!!
Don’t think the formula needs to change.
Not sure what to do so that the ‘time duration’ is properly displayed in view _Detail and view _Table and also the source spreadsheet???
These still show the ‘time duration’ at something other than actual ‘time duration’
I can check the app if you want. I need account ID number and app name.
Nobody else can’t open the app with the ID and app name. And yes I work for Appsheet
Is it ok to post this publicly?
It doesn’t matter but you can send the information to email@example.com. I can read it from there.
Our app isn’t much special.
Regarding security/privacy, are you saying only Appsheet can do anything with the account number and app name?
HOUR(NOW() - MAX(TableName[DateTime]))/24.0+MINUTE(NOW() - MAX(TableName[DateTime]))/1440.0
App Name: HookRate08-596778
The ID is the 596778
Need anything else from me? What is the long code that I thought was the ID?
Not sure why the URL included ‘HookRate08’.
I thought I named the app ‘Hook Rate Development’.