Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
chandinig
Contributor

Displaying date with fraction seconds inQlikview

Hi..

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

Thanks,

1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: Displaying date with fraction seconds inQlikview

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

5 Replies
anbu1984
Honored Contributor III

Re: Displaying date with fraction seconds inQlikview

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

vardhancse
Valued Contributor II

Re: Displaying date with fraction seconds inQlikview

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

Re: Displaying date with fraction seconds inQlikview

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

Not applicable

Re: Displaying date with fraction seconds inQlikview

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

chandinig
Contributor

Re: Displaying date with fraction seconds inQlikview

Hi ..

Thaks for your information..

It helpfull for me...

Thaks,

Community Browser