cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PaulaMcC
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

 

4 REPLIES 4
v-jayw-msft
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])

 

8.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
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

AilleryO
Continued Contributor
Continued Contributor

Hi,

 

You could use something like :

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

Is that OK with you ?

Let us know

Helpful resources

Announcements
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!