format

[antonybi]

need help on converting into date.

date format in source data(.xls)

after loading into qlikview

I have already tried with date(date#(date_field,original_Format),'Desired_Format') but didn't work.

[surendraj]

You can try

=Date('42736','MMM-YY')

[its_anandrjs · Accepted solution]

Try this

=Date(Num#(date))

And attached also

[agigliotti]

your date field is a string rather a number.

could you provide the file "Additional report.xlsx" ?

[its_anandrjs]

For month name

=Date(Date(Num#(date)),'MMM-YY')

Or

=MonthName(Date(Num#(date)))

[OmarBenSalem]

How do you want to it to be be?

[OmarBenSalem]

Try:

MonthName(Date#(MONTH,'MMM-YYYY')) as monthName

or

MonthName(Date(Num#(MONTH))) as monthName

[surendraj]

may be--

Date(Datefield,'MMM-YY')

ex:

Date('42736','MMM-YY')

It will give  Jan-17,Feb17...