how do i apply non null value down the list

[wzhu717]

i am trying to apply 12/29/2023 all the way down, but is keep changing the values. 

i want the output looks like 

Date

12/29/2023 

12/29/2023

12/29/2023

12/29/2023

12/29/2023

can someone please help?

[wzhu717]

[alexnajm]

Why can’t you just use a normal Formula tool and set the Date column to be “12/29/2023”?

[wzhu717]

because the date change in the data every month and i dont want to manually change the formula 

[alexnajm · Accepted solution]

So if the date you are looking for is the first value listed, you can just do [Row-1:Date], making sure you uncheck the grouping and “Set Value to Closest Row” for the Values for Rows that Don’t Exist option. 

[wzhu717]

that works! thank you so much!