topic Date formatting problem in QlikView

Date formatting problem

anthony_kinsell — Wed, 04 Feb 2015 13:22:56 GMT

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 — Wed, 04 Feb 2015 13:25:30 GMT

It looks like ATDATE is already formatted as a date.

Try date(ATDATE) as NewDate

Wed, 04 Feb 2015 13:25:33 GMT

Hello,

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

Colin-Albert — Wed, 04 Feb 2015 13:28:24 GMT

These posts should help

QlikView Date fields

avinashelite — Wed, 04 Feb 2015 13:30:21 GMT

use Date#() and then date this will do

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

Anonymous — Wed, 04 Feb 2015 13:31:51 GMT

can you post a sample qvw

anthony_kinsell — Wed, 04 Feb 2015 14:05:50 GMT

Thanks for the replies,

Unfortunately none of the suggestions work

avinashelite — Wed, 04 Feb 2015 14:35:17 GMT

can you please share the sample data