problem with timestamp

[Anonymous]

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

[Anonymous]

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]

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')

[Ralf-Narfeldt]

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

[Anonymous]

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.

[Anonymous]

Yes.

Regards,

Kumar

[#7]

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

[Anonymous]

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.

[#9]

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

[Anonymous]

pfa