How to convert date format

[#1]

how to convert     

20131022005811 to 22/10/2013                       

[tresB]

Remove quotes around field name, it should work.

Date( Date#( CDAT ,'YYYYMMDDhhMMss'),'DD/MM/YYYY') as Date,

[#3]

its not working

[#4]

i have done each possible thing

[tresB]

Could you share your sample qvw with sample data?

[#6]

Date#(Left(CDAT,2) & '/' &  mid(CDAT,4,2) & '/' & mid(CDAT,7,4),'DD/MM/YYYY') as Date,

wat this function will do ?

[tresB]

This will try to do things in a complex way that Date#() alone can do in a simpler way. .

[#8 · Accepted solution]

Hi,

Check these in Text objects

=Date(Date#('20131022005811' ,'YYYYMMDDhhmmss'),'DD/MM/YYYY')

or 

=Date(Date#(Left('20131022005811',8),'YYYYMMDD'),'DD/MM/YYYY')

If works then use as is in script by replacing with your field without single quotes.

[er_mohit]

Try this in text object

Date(Date#('20131022005811','YYYYMMDDf'),'DD/MM/YYYY')

then in your script side

[#10]

Thanku so much