Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

eg:-2014-sep-11

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

6 Replies
MVP
MVP

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

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

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

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

Not applicable

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

try:

SET DateFormat='YYYY-MM-DD';

Or

SET DateFormat='YYYY/MM/DD';

israrkhan
Valued Contributor II

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

what is your date field and format?

you can try like

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

amit_saini
Honored Contributor III

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

Yogesh,

Try this:

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


Thanks,

AS

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

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

Community Browser