Forum Discussion
Duration on Query Editor vs Time on Visual
Hi Folks! Recently a friend asked me about durations with more than 24 hours. The point is there is an Excel workbook with a worksheet containing a column that represents a duration, but some val...
Thanks, Anonymous .
My curiosity is the data type "DURATION" that I found on Query Editor. It is converted to a Decimal Number when I access de data on Visual.
Did you saw it?
Regards.
Hi Anonymous ,
Yes, duration type only works on query table side. It will been forced convert to decimal value when query table convert to data model table.
As I said, you can split it unit to different fields to keep accurate duration values.
Regards,
Xiaoxin Sheng