Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
I can use the 4th column perhaps it can be usefull to do it.
Thanks
Marco
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
It doesn't work.
Marco
How does your script look like at the moment?
I'm working about it.
Marco
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
Hi,
i am having the same problem. How do I solve it?
Hi,
subfield is howing error.