Displaying date with fraction seconds inQlikview

[Anonymous]

Hi..

I have date field i want to display date with fraction seconds.please help me,

Thanks,

[anbu1984 · Accepted solution]

=Timestamp#('1/1/2014 1:10:10.123','M/D/YYYY h:mm:ss[.fff]')

[vardhancse]

We can change the field format in the properties->Number->Time Stamp

[its_anandrjs]

It is time stamp field or it is date field only, if it is time stamp you can use the

Second(DateField)

If you have any sample provide then.

Regards

Anand

[#5]

=Timestamp#(fieldname,'DD/MM/YYY h:mm:ss[.fff] TT')

[Anonymous]

Hi ..

Thaks for your information..

It helpfull for me...

Thaks,