Hello, I've been searching the community but have not found luck in addressing an issue I am having. I am importing data through Salesforce's Report capability. Of the many rows being processed, only 3 rows have an issue with a specific date field that contans no date and time stamp (mm/dd/yyyy hh:mm:ss AM or PM)
I'd like to know how to add a process or task that analyzes this date column each time a refresh is performed so that when it detects the blank fields, it auto-populates them with some insignificant value. Like 11/11/2011 11:11:11 AM or is there another best practice? I don't care about having 'bad' data that is hard coded in this unique case becasue I would know how to spot it.
I am still not able to replicate the issue... When I have dates formatted as text and then converted to a date, all blank cells are shown as "null" rather than errors. I even tried adding spaces instead of having truly blank cells, but the query editor handled it in the same way. Is there some test data that you can share to help duplicate the issue?
I finally figured out my issue. I thought it was brining in blanks when I looked at the data but it was actually bringing in "Unknown". I converted the "Unknown" to "null" and then changed the type to "date" and it worked. Support was able to help me with this. I believe I was looking at the data after I tried converting to a date instead of prior (which is why I saw blank instead of unknown) AND I forgot to "load more.." results to see in the drop down for the column what it was bringing in besides dates prior to trying to convert to a date.