topic Valid Date check in QlikView https://community.qlik.com/t5/QlikView/Valid-Date-check/m-p/994410#M950562 <HTML><HEAD></HEAD><BODY><P>We have a column that contains dates, strings and integers. The data is CDC data. We have been having issues with the date field coming up as a number (Julian Date) rather than a date. I have tried using the alt function to determine that the date is not shown as a number. Is there any way to resolve this. </P></BODY></HTML> Thu, 10 Dec 2015 18:57:58 GMT 2015-12-10T18:57:58Z Valid Date check https://community.qlik.com/t5/QlikView/Valid-Date-check/m-p/994410#M950562 <HTML><HEAD></HEAD><BODY><P>We have a column that contains dates, strings and integers. The data is CDC data. We have been having issues with the date field coming up as a number (Julian Date) rather than a date. I have tried using the alt function to determine that the date is not shown as a number. Is there any way to resolve this. </P></BODY></HTML> Thu, 10 Dec 2015 18:57:58 GMT https://community.qlik.com/t5/QlikView/Valid-Date-check/m-p/994410#M950562 2015-12-10T18:57:58Z Re: Valid Date check https://community.qlik.com/t5/QlikView/Valid-Date-check/m-p/994411#M950563 <HTML><HEAD></HEAD><BODY><P>For this you need to use date() and date#() to convert and format these values - probably within a few if-loops to catch each varity of dates, strings and numerics.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 10 Dec 2015 20:01:21 GMT https://community.qlik.com/t5/QlikView/Valid-Date-check/m-p/994411#M950563 marcus_sommer 2015-12-10T20:01:21Z Re: Valid Date check https://community.qlik.com/t5/QlikView/Valid-Date-check/m-p/994412#M950564 <HTML><HEAD></HEAD><BODY><P>Could you post some of your data?</P></BODY></HTML> Thu, 10 Dec 2015 20:09:04 GMT https://community.qlik.com/t5/QlikView/Valid-Date-check/m-p/994412#M950564 maxgro 2015-12-10T20:09:04Z