topic Re: Formate date in QlikView

Formate date

Anonymous — Thu, 31 Mar 2016 16:09:23 GMT

Hi,

How to change 03-30-2016 to 03/30/2016.

Thanks,

Krishna

Re: Formate date

Chanty4u — Thu, 31 Mar 2016 16:10:32 GMT

set Dateformat='MM/DD/YYYY';

Re: Formate date

sunny_talwar — Thu, 31 Mar 2016 16:11:28 GMT

May be this:

Date(Date#('03-30-2016', 'MM-DD-YYYY'), 'MM/DD/YYYY')

Re: Formate date

Chanty4u — Thu, 31 Mar 2016 16:11:36 GMT

date(Date#(datefield,'MM-DD-YYYY'),'MM/DD/YYYY') as newdate;

Re: Formate date

clondono — Thu, 31 Mar 2016 16:29:04 GMT

or if you want to format the date at the chart level, in the object properties select the number tab and check "Override Document Settings", highlight the date field. Select date and enter the Format Pattern you are looking for (MM/DD/YYYY)

Re: Formate date

agustinbobba — Thu, 31 Mar 2016 18:12:47 GMT

Hi!,

Try this

DATE(MakeDate(YEAR(Date), MONTH(Date), DAY(MDate)),'DD/MM/YYYY')

Best regards!

Agustin

Re: Formate date

MarcoWedel — Thu, 31 Mar 2016 22:16:13 GMT

depends on where you see this source format.

Can you post a sample?

thanks

regards

Marco