CONVERT DATA YYYYMMDD DD/MM/YYYY

[fmazzarelli]

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

[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]

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

Get the Dates Right

and in this pdf

QlikView Date fields