topic Re: How to display the date format as customization format in QlikView

How to display the date format as customization format

ravindraa — Fri, 27 Nov 2015 05:27:38 GMT

Hi all,

I have struck in one place please help me out to come out form that ,In my data model my date format like this (MM/DD/YYYY) but i need to display the the date format like below (Jan DD) please give me suggestion on this to come out.

Thanks in advance.

Thanks &Regards

Ravindra

Re: How to display the date format as customization format

Anonymous — Fri, 27 Nov 2015 05:36:07 GMT

use Date() function like:

Date(YourDateFiled, 'DD MMM YYYY') as YourDateFiled

Re: How to display the date format as customization format

Anonymous — Fri, 27 Nov 2015 05:37:13 GMT

For your case:

Date(YourDateFiled, 'MMM DD') as YourDateFiled

Re: How to display the date format as customization format

elakkians — Fri, 27 Nov 2015 05:39:25 GMT

Try this

in Expressions:

=Date(Fieldname,'MMM DD')

in Script:

Date(Fieldname,'MMM DD') as Fieldname

Re: How to display the date format as customization format

ravindraa — Fri, 27 Nov 2015 05:49:42 GMT

Hi Balaraj,

Thank you for replay but i have tested in same way but i am getting like below values

I am getting year also including month and date please give me suggestion what mistake i did.

Thanks in advance...............

Re: How to display the date format as customization format

Anonymous — Fri, 27 Nov 2015 05:51:46 GMT

could you share some data sample??

Re: How to display the date format as customization format

Anonymous — Fri, 27 Nov 2015 05:54:16 GMT

see the attachment, its working fine...

Re: How to display the date format as customization format

tamilarasu — Fri, 27 Nov 2015 05:59:13 GMT

Hi Rvindraa,

Try,

=Date(Date#(YourField,'MM/DD/YYYY'),'MMM DD')

Re: How to display the date format as customization format

ravindraa — Fri, 27 Nov 2015 05:59:42 GMT

Hi Balaraj,

Just now i have tested with sample data ,now it is coming but with data base data it is not coming .Do you have any idea in what type of senario' it is not working .

thanks in advance.

Re: How to display the date format as customization format

Kushal_Chawda — Fri, 27 Nov 2015 06:00:08 GMT

try,

date(date#(MonthName_Day,'MMM YYYY DD'),'Needed Format')

Re: How to display the date format as customization format

Anonymous — Fri, 27 Nov 2015 06:05:46 GMT

may be from database, it might be into string format.

Try to convert it into number like Kush suggested with Date# & mention your format

Re: How to display the date format as customization format

ravindraa — Fri, 27 Nov 2015 06:06:58 GMT

Hi all,

Now it is working fine thank you all.

Re: How to display the date format as customization format

nagarjuna_kotha — Fri, 27 Nov 2015 06:10:13 GMT

Try this:

For Example your date field is SalesDate.

Write like this:

>> Date(SalesDate,' MMM DD') as SalesDate_New

Regards,

Nagarjuna