Filtering date range

[SH_94]

Dear community,

Would like to ask if there is any way to filter the date in the string format with the criteria from the date range 20210830 to 20221231.

Input

Thank you

[grazitti_sapna]

@SH_94 , You can change its data type to int using Select tool and then apply below expression in filter tool.

[flying008]

Hi, @SH_94 

1- ToNumber function to filter your date string.

ToNumber([Date]) >= 20210830 && ToNumber([Date]) <= 20221231

2- Convert string to date and filter your date range.

******

If it can help you get your want output, please mark it as s solution and give a like to more share.

[binuacs]

@SH_94 One way of doing this