If date is default (1/1/1900) show blank field

[kattlees]

I'm having an issue with a default date of 1/1/1900. The field is LastDayWorked. When I pull data from the database, a blank field shows as 1/01/1900. On my report, I want it to be blank. 

I have tried a new column of
NewLastDay=IF([LastDateWorked]=1/1/1900,BLANK(),[LastDateWorked]) but it still puts the default date in. I can't change the column type to text. Is there anything that can be done?

[Interkoubess]

Hi @kattlees,

Can you please send sample ( easy to copy and paste for example) data with your case and we wull try to figure out?

Thank you.

Ninter

[kattlees]

Ninter, appreciate you trying to help.

I have a DateLastWorked column that is a Date format. If there is no value entered, it defaults to 1/1/1900

So might have 

Name                DatelastWorked

kathy                      1/1/1900

Sue                         9/15/2017

Jon                         8/30/2017

Ninter                    1/1/1900

I would want it to display as

Name                DatelastWorked

kathy                      

Sue                         9/15/2017

Jon                         8/30/2017

Ninter                   

[Interkoubess · Accepted solution]

Hi @kattlees,

Please try this formula in a column ( I called my table data sample) :

Column = If('Sample'[DatelastWorked]=DATE(1900,01,01),BLANK(),'Sample'[DatelastWorked])

You can see the image below:

Ninter

[kattlees]

Thank you so much. I just didn't have the DATE thing in there.