Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

MAKEDATE code not working properly

Hello my fellow QV friends!  I am having trouble understanding why the code below will not work.  Any ideas?  Thanks

LOAD

    PSSTYL            AS STYLE,

    PSSSFX            AS STYLE_SUFFIX,

    PSSZDS            AS SIZE_DESC,

    If(MIN(PSNUM2)<>0,MakeDate         (   LEFT(MIN(PSNUM2),4),

                                            MID(MIN(PSNUM2),5,2),

                                          RIGHT(MIN(PSNUM2),2)      ),0    ) AS START_SHIP_DATE

WHERE PSNUM2 > 1;

0 Replies