Forum Discussion
default date issue
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.
Greg_Deckler ok that makes perfect sense, I guess I had it the wrong way around, but got pretty close :smileyhappy:
- So why does their have to be a value there? Why can't the date be blank like other types of cells?
Since it seems to be a datetime datatype rather than date, try #datetime(1899, 12, 30, 0, 0, 0) rather than #date(1899, 12, 30) in your ReplaceValue step.
