Date Format not working

sungyunley — Sat, 16 Nov 2024 18:14:01 GMT

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.

Re: Date Format not working

sungyunley — Wed, 12 Aug 2020 18:56:13 GMT

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

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

topic Date Format not working in App Development

Date Format not working

Re: Date Format not working