Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner
Partner

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
its_anandrjs

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

its_anandrjs

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

maxgro
MVP
MVP

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

Get the Dates Right

and in this pdf

QlikView Date fields