Blank date turning into 30/12/1899

[PaulaMcC]

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?

 

[v-jayw-msft]

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,

Jay

[amitchandak]

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

[PaulaMcC]

Thanks @amitchandak 

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

[AilleryO]

Hi,

You could use something like :

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

Is that OK with you ?

Let us know