Date format, full month name

[#1]

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

[JonnyPoole]

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 · Accepted solution]

The string-operations aren't neccessary:

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

- Marcus

[#4]

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