Date Format

[#1]

hi All ,

I wanted to know how to convert the formate from ,   Apr 1,2014   TO   04-10-2014.

Thanks in Advance

[qlikconsultant]

date(yourdateatribute, 'DD-MM-YYYY' )

[jagan]

Hi,

Try like this

Date(Date#(FieldName,  'MMM D,YYYY'), 'MM-DD-YYYY')

Hope this helps you.

Regards,

Jagan.

[#4]

Hi

give

Date(Date#('Apr-10-2014','MMM-DD-YYYY'),'MM-DD-YYYY')

a try

hope that helps

Joe

[#5]

Date(Date#('Apr-10-2014','MMM-DD-YYYY'),'MM-DD-YYYY')

It work fine, if MonthNames variable contain 'Apr'.

[its_anandrjs · Accepted solution]

Hi,

Try this way in any text object

=Date(Date#('Apr 1,2014',  'MMM D,YYYY'), 'MM-DD-YYYY')

Load

Date(Date#(DateField,  'MMM D,YYYY'), 'MM-DD-YYYY') as DateFieldNew

From Location;

Regards

Anand

[Anonymous]

Hi Wrestler,

=Date(ShipDate,'DD-MM-YYYY')

Regards

Neetha

[agomes1971]

Hi,

=Date(Date#(DataTeste,'MMM-DD-YYYY'),'MM-DD-YYYY')

Regards

André Gomes

[maleksafa]

date(date#('Apr 1,2014','MMM D,YYYY'),'DD-MM-YYYY')

[#10]

Thanks anand

u helped me out