Date conversion for Twitter Data

[marco_puccetti]

Hello i need to get the twitter creation date, and this is the format:

How can i convert the Search_created_at  in a comparable date in qlikview?

Thanks

Marco

[Ralf-Narfeldt]

Maybe a stupid question, but can't you use the following two fields that provide a more recognizable timestamp and date? Or maybe they are not availble to you?

[marco_puccetti]

I can use the 4th column perhaps it can be usefull to do it.

Thanks

Marco

[Ralf-Narfeldt]

Indeed it will be more useful.

If you still have problems interpreting that as a date due to your local date settings, this should interpret it correctly:

Date(Date#(Search_created_at_d, 'DD-MMM-YYYY')) As Search_created_at_date

Search_created_at_d would be the name of that 4th column, it's shortened in that picture...

Please mark as Helpful or Answered if you are happy with the answer

[marco_puccetti]

It doesn't work.

Marco

[Ralf-Narfeldt]

How does your script look like at the moment?

[marco_puccetti]

I'm working about it.

Marco

[timanshu]

Load Date(Date#(TempDate, 'DD-MMM-YYYY hh:mm:ss')) as Date;

Load

subfield(Search_created_at,' ',3) & '-'

subfield(Search_created_at,' ',2) & '-'

subfield(Search_created_at,' ',6) & ' '

subfield(Search_created_at,' ',4)

from test.xlsx

as TempDate

[#9]

Hi,

i am having the same problem. How do I solve it?

[#10]

Hi,

subfield is howing error.