how to get date format

[sannidhikumar]

Hi All ,

how to get date format .

and i am using this date(date#([Due Date],'DD-MMM-YYYY'),'MMM-YYYY') AS MonthYear1 not getting correct

output.

to Ex: Jan-2017

thanks ,

[kamal_sanguri]

ok use,

=Date(Date#([Due Date],'YYYY-MM-DD'),'MMM-YYYY')

[qlikview979]

Try like this

Date(Date#(Date#([Due Date]),'DD-MMM-YYYY'),'MMM-YYYY')

[sannidhikumar]

if i am using this field getting empty.

[qlikview979]

Hi Pradeep,

Take [ Due Date] list box,check there how data is coming.it means its coming left side or right side.if you getting left side use first like

Date#([Due Date])

[kamal_sanguri]

I am hoping you are trying to do this( is this your original question) ?

[kamal_sanguri]

Aha, I think I misundertood, you wanted to say that you want new date in YYYY-MM-DD format.

=Date(Date#([Due Date],'DD-MM-YYYY'),'YYYY-MM-DD')

This should work.

[sannidhikumar]

kamal ,

after using that i got that this .

[shanky1907]

Please use this:

=Date(Date#([Due Date],'YYYY-MM-DD'),'MMM-YY')

[qlikview979]

if its possible please share 2 records of data,you will get output with in short period of  time.

[kamal_sanguri]

Follow this.