Date Format not working

[sungyunley]

Hi all, 

I am querying directly from Snowflake and trying to convert a date field from YYYYMMDD to M-D-YY.

So far, I have tried the using DATE(DATE#([SNAPSHOTDATE],'M/D/YYYY'),'YYYYMMDD') as [DATETEST] but its returning null results.

I also tried DATE([SNAPSHOTDATE],'M/D/YYYY') as [DATETEST] but this returns incorrect results. 

Attached are 2 screenshots. One of the snowflake output, you'll see the date field says 20200812; and another of the qlik sense output, where it creates the date as 8/16/57206. 

My end goal is for the 20200812 date to appear as 8-12-20. 

[sungyunley · Accepted solution]

I was able to solve it by swapping out the format to 

DATE(DATE#([SNAPSHOTDATE],'YYYYMMDD'),'M/D/YYYY') as [DATETEST]