Struggling with Date Filter

[langs005]

I am trying to only show dates between two dates and I cannot get the True result to tie out. I get no records/results. 

Custom Filter Used: 

[Completion Date] >= "10/01/2025" AND [Completion Date] <= "07/31/2025"

Example data

Sub Project Number	Full task name	Count	Count Null _ Completion Date	Completion Date
1	A	1	0	12/22/2023 15:17
2	A	1	0	1/29/2025 11:53
4	A	3	0	5/12/2025 12:57
7	F	14	14	[Null]
8	A	11	0	12/5/2024 9:25
9	C	4	0	10/11/2024 15:51
10	G	2	0	9/3/2024 7:46
11	B	1	0	11/1/2023 18:17

[aatalai]

try 

[Completion Date] >= todate("2025-01-10") AND [Completion Date] <= todate("2025-07-31")

[abacon]

@langs005 First, the example data you provided doesn't fall within the range you specified. And the range you specified is impossible to be true, no date is less than 7/31/2025 and greater than 10/1/2025. 

But, you need to put your date column into a date format for alteryx to read - use a datetime parse tool using the settings I provided in the screenshot. Next use a select tool to change the newly output field to a date type, not datetime.

The next step would be to filter your data. Since this is now a date type, you can use the built in functions to filter to what you need.

Bacon

[langs005]

That did not resolve it. But I'm wondering if it has something to do with the DateTime parse. The formatted date does not appear to be working properly either to convert Vstring to date. 

Results: 

[abacon]

@langs005 Click the custom option then use the format I have shown in the date time parse screen shot below.

[langs005]

Almost there: 

[abacon]

@langs005 Slight oversight on my part, use this MM/dd/yyyy hh:mm, not mm/dd/yyyy hh:mm.

Bacon

[binuacs]

@langs005 another way of doing this

toDate(DateTimeParse([Completion Date],'%m/%d/%Y'))>= "2025-01-10" 
AND toDate(DateTimeParse([Completion Date],'%m/%d/%Y')) <= "2025-07-31"