database importing 1/1/1900 RRS feed

  • Question

  • Hello. My databases are importing 1/1/1900 for blank dates. How do I remedy this in Power Pivot. I would want it to be blank correct? 
    Monday, December 12, 2016 8:31 PM


  • Hello, 

    This is something you would want to correct in the source. In case if that option is not possible you always have a choice to use Power Query. You will need to convert your type Date into text and then replace it with blank. 



    Monday, December 12, 2016 10:00 PM