Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
skzwane01
Contributor III
Contributor III

Date not pulling through after conversion

Hi

I have transformed a string data into d date using the Date(Date(SubField(date_time,' ',1),'MM/DD/YYYY')))  conversion. However some of the data is not showing. please see example below.

What does not makes sense is that I have also extracted the time from the string and it works fine.

Please assist.

Date and time.PNG

Thanks

Labels (4)
1 Reply
Anonymous
Not applicable

your date conversion MM/DD/YYYY cannot convert 13/07/2016. 13 is not a valid month
either your date is in format DD/MM/YYYY or your calendar has a special month 13 for
any reason