Dear ideascripting.com users,
as I am working with IDEA, an error occurs if I convert a Char-Field Type to TIME-Field Type after importing from Excel. The problem further explained:
- The Importing Excel Data includes a column with Time-Field Type, but ‘NULL’-Values are included beside of ‘HH:MM:SS’ values (example: 12:09:03).
- IDEA can’t convert ‘NULL’-Values to TIME-Field Type. So I manipulated the Excel Column that all ‘NULL’-Values are replaced with ‘’-Values. This works fine if I want to convert ‘’-Values in IDEA to DATE-Field Type. ‘’-Time Values become ‘0000.00.00’.
- But this won’t work for TIME-Field Type. After Converting ‘’-Values to TIME-Field Type, all former ‘NULL’-Values becomes ‘ERROR’.
It there any possibility to handle with ‘NULL’-Values in TIME-Field Type? If there is no solution, I would let the 'NULL'-Values as 'Errors...