Dear Team, Just to understand. Column name da...

(Etwo Cargo) #1

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?

(Suvrutt Gurjar) #2

Hi @Etwo_Cargo, Please use the expression


[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. - Date and Time Expressions Date and Time Expressions

(Levent KULAÇOĞLU) #3

@Etwo_Cargo Concur with @Suvrutt_Gurjar, you can also try with:

(TODAY() - "00:00:00) - ([DateColumn] - “00:00:00”)

(Etwo Cargo) #4

@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

(Etwo Cargo) #5


(Etwo Cargo) #6

Sorry guys It must be Number type instead of duration. It will show the day.

(Levent KULAÇOĞLU) #7


A quote is forgotten, sorry

(TODAY() - “00:00:00”) - ([DateColumn] - “00:00:00”)

(Etwo Cargo) #8

Thanks a lot Dear Levent.

(Etwo Cargo) #9

@Levent_KULACOGLU Gives me hours. Can we use (TODAY() - “00:00:00”) - ([DateColumn] - “00:00:00”)/24 to have day?