Converting text to date format while importing from web

[#1]

Hello,

I was able to connect to Alerts and Warnings and pull in the table containing Date, Type, and Location. My issue is that the Date is not returning as a date field in Qlikview. I have tried using Data(Date# and other methods but none have completed the task. I am able to connect to it via Excel and it easily recolonizes the date as a date field, not sure how to correct this. Any help would be great! Thank you

[hic · Accepted solution]

You need to tell QlikView what the long Month names are... Do the following

Set LongMonthNames =

          'January;February;March;April;May;June;July;August;September;October;November;December';

LOAD Type,

     Date#(Date,'MMMM DD, YYYY') as Date,

     Location

FROM [http://travel.state.gov/content/passports/english/alertswarnings.html]

(html, codepage is 1252, embedded labels, table is @1);

The MMMM maps against the LongMonthNames.

HIC

[#3]

Thank you!