SOLVED
Extracting data between two dates
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sriniprad08
11 - Bolide
‎03-05-2024
09:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
2 REPLIES 2
16 - Nebula
‎03-05-2024
09:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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".
‎03-05-2024
11:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @gawa. Very helpful
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)