Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
antonybi
Contributor

format

need help on converting into date.

date format in source data(.xls)

Date_format in excel.JPG

after loading into qlikview

incorrect_Format.JPG

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

Tags (1)
1 Solution

Accepted Solutions

Re: format

Try this

=Date(Num#(date))

And attached also

7 Replies
surendraj
Valued Contributor

Re: format

You can try

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

Re: format

Try this

=Date(Num#(date))

And attached also

Partner
Partner

Re: format

your date field is a string rather a number.

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

Re: format

For month name

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

Or

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

Partner
Partner

Re: format

How do you want to it to be be?

Partner
Partner

Re: format

Try:

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

or

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

surendraj
Valued Contributor

Re: format

may be--

Date(Datefield,'MMM-YY')

ex:

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

It will give  Jan-17,Feb17...