Change field Null by Date in the same column

[Jrame]

My problem is quite simple, but as I am new in Alteryx, I could use a little help.
There are certain fields which has [null] value in it and I want to update it by the "Date" in the same column.

Example:

Records   Position date

1               2017/12/29

2               2017/12/29

3               2017/12/29

4               2017/12/29

5              [Null]

Can you suggest me a tool to replace [Null] by a Date.

In function of the report, the date is always the same but not 2017/12/29.

This means that I need a tool or formula who permit to update the Null with the position date at the time of the report.

Thanks in advance

[jdunkerley79 · Accepted solution]

Probably the easiest way is to use a Multi-Row formula tool.

This will copy down the value from the row above. The only catch is that if the data has a null on first line it won't be fixed. You can work around this by sorting first and resorting after.

Sample attached.

[Jrame]

Thanks a lot for your precious help jdunkerley79

It is perfect now