Hi,
I’m trying to substract two timestamps to achieve the duration. So far the formula is the column with the start timestamp minus the ending timestamp of the process. I already set the column type to Duration but it says “Arithmetic expression ‘([TIMEDATE RECIBIDO]-[TIMEDATE RECIBIDO TRANSPORTADOR])’ has inputs of an invalid type ‘Unknown’”
Any thoughts? Thanks for the help!
Solved! Go to Solution.
@AlejandroCamacho
Set the expression like this:
([TIMEDATE RECIBIDO] - "000:00:00") - ([TIMEDATE RECIBIDO TRANSPORTADOR] - "000:00:00")
@AlejandroCamacho
Set the expression like this:
([TIMEDATE RECIBIDO] - "000:00:00") - ([TIMEDATE RECIBIDO TRANSPORTADOR] - "000:00:00")
Hi Levent! Good to read from you again!
I tried your solution but it shows the same message:
I’m I missing something? Thanks again!
@AlejandroCamacho
Are those [TIMEDATE RECIBIDO] and [TIMEDATE RECIBIDO TRANSPORTADOR] columns DATETIME type?
Yep… that was it, so sorry to have missed that. Thank you so much!
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |