Convert YYYYMMDD to DD/MM/YYYY - Self-learning Qlikview Newbie

[#1]

Hi           

I am trying to load data from SQL server using a OLE DB connection and would like to convert the data in the columns suffixed with the word Date (in Bold) from YYYYMMDD to DD/MM/YYYY format. Please Help.

The script I am using to load the data is:

SQL SELECT AccountingYearMonth as AccountingPeriod,

    AdmiDate AS StartDate,

    Age,

    SpellDisDate AS DischargeDate,

SpellDominantProcedure AS DominantProcedureSpell,

    SpellLoS AS LoS,

FROM SLAM.dbo."1415SLAMTAS";

Please reply with an amendment to the script

many thanks

[swuehl]

If QV interpretes the dates correctly, you just need to format in a preceding LOAD (or use formatting options of your source DBMS in the SQL part):

LOAD

     AccountingPeriod,

    Date(StartDate, 'DD/MM/YYYY') AS StartDate,

    Age,

    Date(DischargeDate,'DD/MM/YYYY') AS DischargeDate,

    DominantProcedureSpell,

    LoS;

SQL SELECT AccountingYearMonth as AccountingPeriod,

    AdmiDate AS StartDate,

    Age,

    SpellDisDate AS DischargeDate,

SpellDominantProcedure AS DominantProcedureSpell,

    SpellLoS AS LoS,

FROM SLAM.dbo."1415SLAMTAS";

[Colin-Albert]

There are some useful posts on dates and formatting here:

https://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

https://community.qlik.com/docs/DOC-3102

[prabhu0505]

Date(Date#(AdmiDate, 'YYYYMMDD'), 'DD/MM/YYYY') AS StartDate

Date(Date#(SpellDisDate, 'YYYYMMDD'), 'DD/MM/YYYY') AS DischargeDate