Graphics

Hello support

I have a little bit of an urgent problem and don't know how to solve it. In my xls table there are two columns with times I need to access. In Excel, both columns are formatted as time (hh:mm:ss) and appear correctly - but inside XPression however, when accessing the data through datalinq, somehow the "null"-date of Excel is added in front of the time and the time now appears like this:

30.12.1899 00:26:11

instead of:

00:26:11

Since my client uses XPression Prime I can't solve this issue with a script. I've tried different formatting in Excel, but it won't do the trick. Is there a parameter in datalinq I need to change?

Thank you in advance

Remo

Is there no solution to this issue?
#XPression

by default , Excel store this kind of value as Date type
You can force in Excel your cells to be stored as string : it will solve you issue.

Select your column , right click -> "Format Cells..." it will show a pop-up where you can change data format to "text"

#XPression