Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
ravindraa
Creator
Creator

How to display the date format as customization format

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

12 Replies
Anonymous
Not applicable

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

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

ravindraa
Creator
Creator
Author

Hi all,

  Now it is working fine thank you all.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Try this:

For Example your date field is SalesDate.



Write like this:

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

Regards,

Nagarjuna