Re: Date formatting problem - Qlik Community

anthony_kinsell · ‎2015-02-04

Hi,

I'm trying to format a date & had entered the below script:

	ATDATE,
	Date(Left(ATDATE,10),'DD/MM/YYYY') as Date,

However this doesn't seem to be having any effect on the data - see table extract below:

Anyone any ideas as to what I'm doing wrong / missing?

Cheers

Anthony

Colin-Albert · ‎2015-02-04

It looks like ATDATE is already formatted as a date.

Try date(ATDATE) as NewDate

Report Inappropriate Content · ‎2015-02-04

Hello,

Date(Date#(Left(ATDATE,10),'DD/MM/YYYY'),'DD/MM/YYYY') as Date,

Colin-Albert · ‎2015-02-04

These posts should help

QlikView Date fields

avinashelite · ‎2015-02-04

use Date#() and then date this will do

Date(Date#(Left(ATDATE,10),'DD/MM/YYYY'),'DD/MM/YYYY') as Date

Anonymous · ‎2015-02-04

can you post a sample qvw

anthony_kinsell · ‎2015-02-04

Thanks for the replies,

Unfortunately none of the suggestions work

avinashelite · ‎2015-02-04

can you please share the sample data