Dear Team, Just to understand. Column name day.
Type is Duration. Inside of column settings AppFormula is today()-[date] error message: The expression is valid but its result type โDurationโ is not one of the expected types: Number
I am trying answer for โhow many day still in warehouseโ? So means that (if day is 29.11.2018) 04.12.2018-29.11.2018 = 5
Is the formula is wrong?
Hi @Etwo_Cargo, Please use the expression
HOUR(TODAY() -
[Date]) /24
Since the result (days) is in numbers, the column type needs to be number type.
The above expression
is described in the article below under topic โComplex Expressionsโ as 5th bullet point.
help.appsheet.com - Date and Time Expressions Date and Time Expressions help.appsheet.com
@Etwo_Cargo Concur with @Suvrutt_Gurjar, you can also try with:
(TODAY() - "00:00:00) - ([DateColumn] - โ00:00:00โ)
@Levent_KULACOGLU when i try that one. (today()"00:00:00) - ([date] - โ00:00:00โ) Expression โ(today()"00:00:00) - ([date] - โ00:00:00โ)โ could not be parsed due to exception: Unterminated string.@Suvrutt_Gurjar
#ERROR!
Sorry guys It must be Number type instead of duration. It will show the day.
A quote is forgotten, sorry
(TODAY() - โ00:00:00โ) - ([DateColumn] - โ00:00:00โ)
Thanks a lot Dear Levent.
@Levent_KULACOGLU Gives me hours. Can we use (TODAY() - โ00:00:00โ) - ([DateColumn] - โ00:00:00โ)/24 to have day?
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |