This is my table.
How can I set the date in DD / MM/ YYYY and the time in hh:mm:ss ?
In the load script, use formatting functions date() and timestamp().
In the UI, open Document Properties > Number and format the fields accordingly.
I think I must do there
make there an expression
For Expressions, you could use the Date function within the Expression.
For Dimensions, though, the only way is to format the field in the Document Properties > Number.
You can write in script below expressions.
Date(Date#(Date2,Num(Date2)),'DD/MM/YYYY') as Date3,
Time(Time#(Time2,Num(Time2)),'hh:mm::ss') as Time3,
Retrieving data ...