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. AccountCurrent DatePrevious DateAction Date234523423446/2/20235/26/2023 0:003/23/202345454545345[Null][Null]5/28/202345454545345[Null][Null]3/23/202345454545345[Null][Null]5/30/202345454545345[Null][Null]6/1/20234.54352E+13[Null][Null]3/29/2023

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

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.

Workflow

Datasets

Input

Custom Tools

Macros

Join

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

@ericren One way of doing this

"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

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

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

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

@ericren One way of doing this