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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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