Replace NULL value for DATE type

[macabrera]

Hi, 

I have a file like this

And I wold like to replace the NULL values with the previuos Date + 1. So I have something like this

2014-07-01    152071662.1

2014-07-02    151898406.3

2014-07-03    151725150.4

and so on...

Thanks, 

[chris_love · Accepted solution]

Use the MultiRowFormula for this

use IF isnull([Date]) then DateTimeAdd([Row-1:[Date],1,"days") else [Date] end

obviously where Date is the column you are updating.

[macabrera]

Thanks....

It works, but just for the first NULL record :(

[chris_love · Accepted solution]

Ah - in that case you need to make sure you UPDATE the existing Date column, at the minute I imagine you are creating a new column so it doesnt see the previous one using Row-1

[macabrera]

Yes... Thanks... I realize this the next minute i posted the last comment

Thanks 

:)

[jgaytan20]

I need something similar to the case above. If column "Tax date" is blank, then I need it to return the first of the year (1/1/2017), otherwise keep the existing date. How can I do this?