Extract rows of information based on two dates

[sriniprad08]

Hi Team,

Hope you are well.

I need help. I have two date field and i need to extract the data between these two dates

1) Date period - 2023-01-01 to 2024-01-02

Criteria ([START DATE] BETWEEN  "2023-01-01" and  "2024-01-02" ) AND ([END DATE] BETWEEN  "2023-01-01" and  "2024-01-02" )

Please let me know how to go about it,

Thanks

Sr

[ChrisTX · Accepted solution]

If your fields are data type Date, try

[Start Date] >= "2023-01-01" AND
[Start Date] <= "2024-01-02" AND
[End Date] >= "2023-01-01" AND
[End Date] <= "2024-01-02"

You have to write out all of the >= and <= because Alteryx doesn't have a BETWEEN operator.

Chris