Have a problem with the Date function.

[#1]

  This is my actual data and I want it in this form:  

Date	Sales
Jun-2016	250,789.00
Jul-2016	298,780.00
Aug-2016	293,530.00
Sep-2016	300,732.00
Oct-2016	298,572.00
Nov-2016	331,043.00
Dec-2016	315,519.00
Jan-2017	362,522.00
Feb-2017	305,626.00
Mar-2017	338,963.00
Apr-2017	313,843.00
May-2017	351,418.00

But what I see in Qlikview is

Date	Sales
42551	250,789.00
42582	298,780.00
42613	293,530.00
42643	300,732.00
42674	298,572.00
....	331,043.00
.....	315,519.00
	362,522.00
	305,626.00
	338,963.00
	313,843.00
	351,418.00

...

How can I get the data in that format

[tresesco · Accepted solution]

When creating date in the script, finally put date() around your expression like:

Load

          Date( YourCurrentDateField, 'MMM-YYYY') as NewDate

[vinieme12]

go to number tab >> Select Date >> Edit format to MMM-YYYY

[Chanty4u]

or else try with

Date(Date#(DateField,'MMM-YYYY'),'MMM-YYYY') as NewDate