
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The string-operations aren't neccessary:
=date(date#('September 19, 2014', 'MMMM DD, YYYY'), 'DD/MMM/YYYY')
- Marcus

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The string-operations aren't neccessary:
=date(date#('September 19, 2014', 'MMMM DD, YYYY'), 'DD/MMM/YYYY')
- Marcus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
