Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

antonybi
New Contributor III

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

agigliotti
Honored Contributor II

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)))

OmarBenSalem
Esteemed Contributor

Re: format

How do you want to it to be be?

OmarBenSalem
Esteemed Contributor

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...

Community Browser