Date formatting problem

[anthony_kinsell]

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]

It looks like ATDATE is already formatted as a date.

Try      date(ATDATE) as NewDate

[#3]

Hello,

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

[Colin-Albert]

These posts should help

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

QlikView Date fields

http://community.qlik.com/docs/DOC-3102

[avinashelite]

use Date#() and then date this will do

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

[Anonymous]

can you post a sample qvw

[anthony_kinsell]

Thanks for the replies,

Unfortunately none of the suggestions work

[avinashelite]

can you please share the sample data