topic Re: Date and time in QlikView

Date and time

Wed, 25 Mar 2015 14:02:26 GMT

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 — Wed, 25 Mar 2015 14:06:33 GMT

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

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

Wed, 25 Mar 2015 14:14:41 GMT

I think I must do there

Wed, 25 Mar 2015 14:15:19 GMT

make there an expression

Wed, 25 Mar 2015 14:27:38 GMT

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 — Wed, 25 Mar 2015 14:34:23 GMT

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.