Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date format, full month name

Hi,

I'm loading data with the following date format: September 19, 2014

I've tried the below in qlikview, the result looks good, but is still not recognized as a date.

DATE# (LEFT(Right(DateField,8),2) & '/' & Left(DateField,3) & '/' & Right(DateField,4), 'DD/MM/YYYY') As Date

Any ideas?

Kind REgards,

Olle

1 Solution

Accepted Solutions
marcus_sommer

The string-operations aren't neccessary:

=date(date#('September 19, 2014', 'MMMM DD, YYYY'), 'DD/MMM/YYYY')

- Marcus

View solution in original post

3 Replies
JonnyPoole
Former Employee

If the format looks good, try wrapping it in a Date() function.  Date# is for interpretation of source data, Date is for formatting. 


Date(DATE# (LEFT(Right(DateField,8),2) & '/' & Left(DateField,3) & '/' & Right(DateField,4), 'DD/MM/YYYY')) As Date

marcus_sommer

The string-operations aren't neccessary:

=date(date#('September 19, 2014', 'MMMM DD, YYYY'), 'DD/MMM/YYYY')

- Marcus

Not applicable
Author

HI,

Please follow the below link. Its an excellent post on dates and dates interpretation.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/12/02/the-date-function