Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
antonybi
Creator
Creator

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.

1 Solution

Accepted Solutions
its_anandrjs

Try this

=Date(Num#(date))

And attached also

View solution in original post

7 Replies
surendraj
Specialist
Specialist

You can try

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

its_anandrjs

Try this

=Date(Num#(date))

And attached also

agigliotti
Partner - Champion
Partner - Champion

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

may be--

Date(Datefield,'MMM-YY')

ex:

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

It will give  Jan-17,Feb17...