Multiple dates issue

Wed, 06 Feb 2013 18:46:43 GMT

i've date field and other columns. Date fields has multiple date formats for eg it has date in dd/mm/yyyy and mm/dd/yyyy

i want date in dd/mm/yyyy format. dates in mm/dd/yyyy should also be converted into set format which is dd/mm/yyyy.

Date

12/1/2012

12/2/2012

12/3/2012

25/4/2012

12/5/2012

12/6/2012

22/7/2012

12/8/2012

12/9/2012

12/10/2012

12/11/2012

12/12/2012

12/13/2012

12/14/2012

12/15/2012

In the above table i've 2 date formats. So where month is field is greater then 12 it should take it as date and change the date format otherwise set format for date which is dd/mm/yyyy.

thanks

Re: Multiple dates issue

spsrk_84 — Wed, 06 Feb 2013 20:06:12 GMT

Hi ,

I have taken the dates which you had mentioned in your post & converted different formats into DD/MM/YYYY format.

Please find attached Qvw for your reference.

Thanks,

Shiva

topic Re: Multiple dates issue in QlikView

Multiple dates issue

Re: Multiple dates issue