Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Blank date turning into 30/12/1899

Hi All,


I have a lookupvalue column which is pulling a date from another table and then a further 3 columns with future dates based on the looked up date. However if the date is 0 it turns to 30/12/1899 and that then affects the other 3 columns but I don't know how to tell it to keep it empty. I have tried "null" but didn't like it. Could someone help me fix the formula?


 Screenshot 2021-02-16 161205.png



Screenshot 2021-02-16 161224.png


Community Support
Community Support

Hi @PaulaMcC ,


As the column is date format, 0 will be converted to 1899/12/31

The formula will return blank value defaultly, what's the expected result?


Column = LOOKUPVALUE('Table'[date],'Table'[name],'Table 2'[name])




Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User
Super User

@PaulaMcC , in case of blank, do not return 0. return blank()

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thanks @amitchandak 

That works but it's still affecting the further 3 columns, any idedas?


Screenshot 2021-02-16 163935.png

Continued Contributor
Continued Contributor



You could use something like :

IF(ISBLANK(StartDate),BLANK(),DATEADD(bla bla)) ?

Is that OK with you ?

Let us know

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!