Replace NULL value for DATE type

macabrera

Hi,

I have a file like this

Date file.jpg

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,

Date Time

Accepted answers

chris_love

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.

chris_love

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

All comments

chris_love

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

Date file.jpg

chris_love

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703