Fill down columns from the first row data AND filter by date

[ericren]

Hi Alteryx community,

See below.

For Current Date I want to fill down with the constant date  6/2/2023. 

For Previous Date I want to fill down with the Current Date - 7 days. 

Finally I want all rows with Action date between current date and previous date.

Account	Current Date	Previous Date	Action Date
23452342344	6/2/2023	5/26/2023 0:00	3/23/2023
45454545345	[Null]	[Null]	5/28/2023
45454545345	[Null]	[Null]	3/23/2023
45454545345	[Null]	[Null]	5/30/2023
45454545345	[Null]	[Null]	6/1/2023
4.54352E+13	[Null]	[Null]	3/29/2023

[FrederikE]

Hey @ericren

"Between" as a function is availible since 2023.1 - if you haven't got this you can use 

[Action Date]> [Previous Date] AND [Action Date]<[Current Date]

Instead

[ericren]

No sure why, the current date and previous date columns are not filling in. Would I need to use a multi field formula?

[FrederikE · Accepted solution]

Hey @ericren,

Ah, you want to populate the first value downwards - Missunderstood you there. Multi-Row is the tool for this.

[ericren]

Yeah Im having issues with the rows filling, see below if we are getting the same result. 

[binuacs · Accepted solution]

@ericren One way of doing this