Discussion Board for collaboration related to QlikView App Development.
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.
your date conversion MM/DD/YYYY cannot convert 13/07/2016. 13 is not a valid montheither your date is in format DD/MM/YYYY or your calendar has a special month 13 forany reason