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: 
Not applicable

how get date format like yyyy-mon-dd????

eg:-2014-sep-11

please tell me guyes its to urgent!!!!!!!!!!!!!!!!!!!!!!!

6 Replies
tresesco
MVP
MVP

Date(DateField, 'YYYY-MMM-DD')

ashfaq_haseeb
Champion III
Champion III

=date(today(),'YYYY-MMM-DD')

Not applicable
Author

try:

SET DateFormat='YYYY-MM-DD';

Or

SET DateFormat='YYYY/MM/DD';

israrkhan
Specialist II
Specialist II

what is your date field and format?

you can try like

date(yourDateField,'YYYY-MMM-DD')

amit_saini
Master III
Master III

Yogesh,

Try this:

date(date#(fieldname,'YYYY-MMM-DD'),'YYYY-MMM-DD')


Thanks,

AS

MK_QSL
MVP
MVP

It all depends on what is your current format of Date field...!!!