Forum Discussion
default date issue
I'm having an issue with my date fields that I can't figure out. 1. Whenever I pull in date columns, Power BI defaults them as Date/Time columns, rather than Date columns (I'm guessing this is b...
Hi kincaids, what about if you had to modify the default date from 12/30/1899 to something more recent?
I am going to take a real guess here, and that might be in the Query Editor it has some date in the past that it will not go to previously?
Or an alternative would possibly be, is before changing the data type to date time, leave it as Text, then try and replace the values with NULL?
NOTE: You can often insert a step before the default "Changed Type"
I believe that 12/30/1899 is Power BI's "default reference date". That's why he's seeing that when there are null values. I ran into this when dealing with dates before 12/30/1899 in OSU football data.