topic Re: DATE FORMAT? in QlikView

DATE FORMAT?

Anonymous — Mon, 09 Mar 2015 06:58:23 GMT

HI,

i have date like this

1/2/1015_02_04

i want get like 01/02/2015 i dont want get any other thing here?

Re: DATE FORMAT?

arulsettu — Mon, 09 Mar 2015 07:03:15 GMT

hi try like this

Date(Date#('1/2/1015_02_04','DD/MM/YYYY_HH_MM'),'DD/MM/YYYY')

Re: DATE FORMAT?

jagan — Mon, 09 Mar 2015 07:15:39 GMT

Hi,

Try like this

Date(Date#('1/2/2015_02_04', 'M/D/YYYY_hh_mm', 'MM/DD/YYYY')

Date(Date#('1/2/2015_02_04', 'D/M/YYYY_hh_mm', 'DD/MM/YYYY')

Hope it helps you.

Regards,

Jagan.

Re: DATE FORMAT?

prma7799 — Mon, 09 Mar 2015 07:18:29 GMT

Try below

=Date(Date#('1/2/2015_02_04', 'D/M/YYYY_hh_mm'), 'DD/MM/YYYY')

Thanks

Re: DATE FORMAT?

mukesh24 — Mon, 09 Mar 2015 07:32:03 GMT

hi,

Try as

Date(Date#('1/2/2015_02_04', 'D/M/YYYY_hh_mm'))

Re: DATE FORMAT?

puttemans — Mon, 09 Mar 2015 08:05:32 GMT

Hello,

This document from HIC may help you.

Re: DATE FORMAT?

tyagishaila — Mon, 09 Mar 2015 08:08:09 GMT

Try it,

Date(date, 'DD/MM/YYYY') as date,

here date is your attribute name

Re: DATE FORMAT?

Wed, 11 Mar 2015 13:50:58 GMT

Hi Jagan,

Here I have dates like this below,all are having format is DD/MM/YYYY

but here i have a issue is 02/03/2015 and 2/3/2015 is giving as two values in list box.

i need all the below values into any of the one format.

02/03/2015

2/3/2015

1/03/2015

05/03/2015

6/3/2015

7/03/2015

i want it like

02/03/2015

01/03/2015

05/03/2015

06/03/2015

07/03/2015

Plz help me i tried but i didn't get any solution for this.

Re: DATE FORMAT?

jagan — Thu, 12 Mar 2015 05:30:39 GMT

Hi,

Can you attach some sample data?

REgards,

Jagan.

Re: DATE FORMAT?

senpradip007 — Thu, 12 Mar 2015 05:38:20 GMT

Try to use this....

date(SubField('1/2/1015_02_04', '_'), 'DD/MM/YYYY')