Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

CONVERT DATA YYYYMMDD DD/MM/YYYY

Hi,

how to convert a date in yyyymmdd to format dd / mm / yyyy

example:

Date: 20161101 (YYYYMMGG)

to

Date: 01/11/2016

and viceversa.

From date: DD/MM/YYYY

To date: YYYYMMDD

3 Replies

Re: CONVERT DATA YYYYMMDD DD/MM/YYYY

Try some of this

Date(Date#(20161101,'YYYYMMDD'),'DD/MM/YYYY')

Or

Date(Date#(DateField,'YYYYMMDD'),'DD/MM/YYYY')

Or

Date(20161101,'DD/MM/YYYY')

Or

Date(DateField,'DD/MM/YYYY')

Regards

Anand

Re: CONVERT DATA YYYYMMDD DD/MM/YYYY

Please find the attached one with any date field how to do this also please assure you have proper date field

LOAD * ,Date(Date#(DateField,'YYYYMMDD'),'DD/MM/YYYY') as FormatedField;
LOAD * Inline
[
DateField
20161101
]
;


If you have proper date field then use this


LOAD

  *

Date(DateField,'DD/MM/YYYY') as FormatedField
From Location;


Regards

Anand

MVP
MVP

Re: CONVERT DATA YYYYMMDD DD/MM/YYYY

you can find a lot of usefule info on date conversion here

Get the Dates Right

and in this pdf

QlikView Date fields