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 NumberFull task nameCountCount Null _ Completion DateCompletion Date1A1012/22/2023 15:172A101/29/2025 11:534A305/12/2025 12:577F1414[Null]8A11012/5/2024 9:259C4010/11/2024 15:5110G209/3/2024 7:4611B1011/1/2023 18:17

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

Struggling with Date Filter

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

Date Time

Accepted answers

All comments

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:

binu_acs

@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"

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703