Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kattlees
Post Patron
Post Patron

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

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?

1 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:

 

Date.PNG

 

Ninter

 

 

View solution in original post

4 REPLIES 4
Interkoubess
Solution Sage
Solution Sage

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

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                   

 

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:

 

Date.PNG

 

Ninter

 

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.