topic Re: problem with timestamp in QlikView

problem with timestamp

Anonymous — Wed, 01 Apr 2015 09:24:42 GMT

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

Re: problem with timestamp

Anonymous — Wed, 01 Apr 2015 09:33:30 GMT

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

Re: problem with timestamp

malini_qlikview — Wed, 01 Apr 2015 09:34:28 GMT

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

Re: problem with timestamp

Ralf-Narfeldt — Wed, 01 Apr 2015 09:37:25 GMT

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

Re: problem with timestamp

Anonymous — Wed, 01 Apr 2015 09:38:32 GMT

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.

Re: problem with timestamp

Anonymous — Wed, 01 Apr 2015 09:39:57 GMT

Yes.

Regards,

Kumar

Re: problem with timestamp

Wed, 01 Apr 2015 09:42:30 GMT

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

Re: problem with timestamp

Anonymous — Wed, 01 Apr 2015 09:43:32 GMT

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.

Re: problem with timestamp

Wed, 01 Apr 2015 09:44:43 GMT

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

Re: problem with timestamp

Anonymous — Wed, 01 Apr 2015 09:46:00 GMT

pfa

Re: problem with timestamp

Ralf-Narfeldt — Wed, 01 Apr 2015 09:48:17 GMT

And if you do a Num([Time Full Date])?

Re: problem with timestamp

Wed, 01 Apr 2015 09:48:54 GMT

try like this:

=Date(Floor(Timestamp#(FieldName, 'YYYY-DD-MM hh:mm:ss')),'YYYY-MM-DD')

Re: problem with timestamp

Wed, 01 Apr 2015 09:49:01 GMT

Hi Kumar,

try like this....

Floor(TimeStamp) As date

Date(floor(MyTimestamp)) as MynewDate

Date(Floor(Timestamp#(FieldName, 'YYYY-DD-MM hh:mm:ss')),'YYYY-MM-DD') as Date

Re: problem with timestamp

Anonymous — Wed, 01 Apr 2015 09:59:21 GMT

No, it is not working.

Re: problem with timestamp

Anonymous — Wed, 01 Apr 2015 10:00:11 GMT

No, it is not working.

Re: problem with timestamp

Wed, 01 Apr 2015 10:01:52 GMT

can you please add the file with Data then we can help you better.

Re: problem with timestamp

Anonymous — Wed, 01 Apr 2015 10:03:52 GMT

Load a more column in your script

Date(floor(Num(FieldName))) as Date

then use it in list box. Hope this will help

Thanks

BKC

Re: problem with timestamp

Wed, 01 Apr 2015 10:06:23 GMT

Hey Kumar,

ping us current time stamp format and expected date format.

Re: problem with timestamp

Ralf-Narfeldt — Wed, 01 Apr 2015 10:08:36 GMT

This should work:

date(timestamp#([Time Full Date],'YYYY/MM/DD h:mm:ss'),'DD/MM/YYYY')

Re: problem with timestamp

PrashantSangle — Wed, 01 Apr 2015 10:13:36 GMT

Hi,

2 ways to acheive it

1)subfield([Time Full Date],' ',1)

2) date(timestamp#([Time Full Date],'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY')

timestamp(timestamp#([Time Full Date],'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY')

date(date#([Time Full Date],'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY')

Regards