Hi,
I'm loading an igGrid with date fields, but when the data is null it displays 1/1/1 instead of a blank column.
How can I display a blank column when the date is null? Do I need to use the column formatter and write a java script function to clear the 1/1/1 value?
Thanks
I've attached a simple HTML sample that uses the igGrid with one Date column - as you can see, the first two rows have a NULL value and its rendered as an empty string.If possible, can you:1. Take a look at the sample I've attached to my reply and let me know if there are any differences from your scenario?2. Let me know which build you are using? (I tried the latest Service Release build - #2084) 3. If you can compose a similar HTML sample where the problem can be reproduced, can you attach it to your next reply so I can take a closer look?Thanks in advance!Cheers,Borislav
I was able to fix the issue by assigning null to the date values instead ot DateTime.MinValue. The column now has a null value instead of DateTime.MinValue, therefore it displays an empty cell.
Glad you found the cause of the issue.Let us know if you need assistance with anything else.PS: I suspect that this is actually caused by the .NET framework's JSON serializer - if you supply it with a DateTime.Min value, it will serialize it as a valid date so the igGrid receives that as a response from the server.