Extracting data between two dates

[sriniprad08]

Hi Team,

Hope you are well.

I have to extract data between two dates

how can i go about it in alteryx,

where [STARTDATE] >= '2023-07-01 00:00:00' and [ENDDATE] <= '2024-01-31 00:00:00'

thanks for the help,

Sri

[gawa · Accepted solution]

hi @sriniprad08 

If you are looking for the equivalent tool to WHERE clause in SQL, first choice should be Filter tool.

When you need to filter the condition by multiple fields, select "Custom filter".

[sriniprad08]

Thank you @gawa. Very helpful