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.
kumarreddy257
Contributor

problem with timestamp

Hi,

I am trying to convert time stamp into date, but i am not able to convert it.

I tried it =

date([Time Full Date],'DD/MM/YYYY') and the expression is ok,but in list box it is displaying nothing. Not only in listbox in all reports the same problem.

Pls help me on this.

Regards,

kumar

20 Replies
hrlinder
Honored Contributor

Re: problem with timestamp

what is the current date format?

maybe you need to convert it to a dateformat using date#

e.g. date(date#([Time Full Date],'YYYY-MM-DD'),'DD/MM/YYYY') if your dateformat now is YYYY-MM-DD

Check your date format and adjust it in the expression above in the date# part

malini_qlikview
Contributor II

Re: problem with timestamp

I guess you need to remove timestamp and restore only date from the field.You can use rounding function to remove timestamp,

=Date(Floor(Now()),'DD/MM/YYYY')

Employee
Employee

Re: problem with timestamp

Are you sure Time Full Date is recognized as a valid timestamp when you have loaded?

kumarreddy257
Contributor

Re: problem with timestamp

Hi,

My date format is YYYY-MM-DD.

I tried as said, but it is not giving any results. I am able to convert now() into date format.

kumarreddy257
Contributor

Re: problem with timestamp

Yes.

Regards,

Kumar

Not applicable

Re: problem with timestamp

Can you upload the file? so we can check it?

kumarreddy257
Contributor

Re: problem with timestamp

this is how the result giving without applying date([Time Full Date],'DD/MM/YYYY')

i tried with just [Time Full Date] and it is giving below result.

Not applicable

Re: problem with timestamp

Use Subfield([Time Full Date],' ',1) or Left([Time Full Date], 10)

kumarreddy257
Contributor

Re: problem with timestamp

pfa

Community Browser