Hello, I have a problem with the Datagrid in visual basic 6 (sp5) where the data in the date column asspeas as nothing if it is a date or if it isnt a date. I believe that its a problem with the conflicting data types, i was wondering if its possible to get MySQL to convert a type (such as date) to a string or is there something i am missing ? My sql statement is SELECT IF(date is null, NoDateReason, Date_Format(Date,'%d/%m/%Y')) as date from dates; The date field type is DATE and NoDateReason is text The query works fine when displayed in a flex grid but i would prefer not to have to use a flex grid or manually populate the data grid. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
