topic Re: Date Format in QlikView

Date Format

Thu, 27 Nov 2014 09:03:11 GMT

hi All ,

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

Thanks in Advance

Re: Date Format

qlikconsultant — Thu, 27 Nov 2014 09:09:20 GMT

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

Re: Date Format

jagan — Thu, 27 Nov 2014 09:10:52 GMT

Hi,

Try like this

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

Hope this helps you.

Regards,

Jagan.

Re: Date Format

Thu, 27 Nov 2014 09:11:30 GMT

give

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

a try

hope that helps

Joe

Re: Date Format

Thu, 27 Nov 2014 09:11:30 GMT

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

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

Re: Date Format

its_anandrjs — Thu, 27 Nov 2014 09:14:05 GMT

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

Re: Date Format

Anonymous — Thu, 27 Nov 2014 09:14:18 GMT

Hi Wrestler,

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

Regards

Neetha

Re: Date Format

agomes1971 — Thu, 27 Nov 2014 09:18:03 GMT

Hi,

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

Regards

André Gomes

Re: Date Format

maleksafa — Thu, 27 Nov 2014 09:25:36 GMT

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

Re: Date Format

Thu, 27 Nov 2014 09:34:59 GMT

Thanks anand

u helped me out