Date and time

[#1]

This is my table.

How can I set the date in DD / MM/ YYYY and the time in hh:mm:ss ?

Thank you!

[Oleg_Troyansky]

In the load script, use formatting functions date() and timestamp().

In the UI, open Document Properties > Number and format the fields accordingly.

[#3]

I think I must do there

[#4]

make there an expression

[#5]

Hi,

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,

[Oleg_Troyansky]

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.