topic Re: Date format in QlikView

Date format

kevbrown — Thu, 28 Apr 2016 08:26:48 GMT

Hi,

I have a spreadsheet which contains a date column. However, some of the dates are formated as dd/mm/yyyy and some are dd.mm.yyyy. Is there a way of formatting all these date as dd/mm/yyyy

Thanks

Re: Date format

Thu, 28 Apr 2016 08:30:21 GMT

Try like below,

alt(date(date#(DateField,'dd/mm/yyyy'),'DD-MM-YYYY'),date(date#(DateField,'dd.mm.yyyy'),'DD-MM-YYYY')) as Date

Re: Date format

MK_QSL — Thu, 28 Apr 2016 08:31:52 GMT

Date(Alt(

Date#(DateField,'DD/MM/YYYY'),

Date#(DateField,'DD.MM.YYYY')

),'DD/MM/YYYY') as DateField

Re: Date format

PrashantSangle — Thu, 28 Apr 2016 08:32:47 GMT

Hi,

use MM(capital) instead of mm(lower case)

mm-> denotes minutes

MM-> denotes Month

Kind Regards