Filter data column "Column type not supported"

[thotlamahesh_kumar (Reyhitu)]

Date.ParseExact(“Bill Date”,“MMddyyyy”, System.Globalization.CultureInfo.InvariantCulture)

Date.ParseExact(“Biweekly Calender”,“MMddyyyy”, System.Globalization.CultureInfo.InvariantCulture )

I am using above names in the filter column wizard but i am getting error

The Bill Date and Biweekly Calender both are column names which datevalues in the excel file

Do we have any other way to compare with Date field if date has previous or future year then we need to add that sheet to name output file?

I have multiple sheets which have date fields so i need check whether any sheet has previous year or future year?

[V_Roboto_V]

Hi @thotlamahesh_kumar

I guess in the Column part, you have to mention Column Name not Date.Parse…

[thotlamahesh_kumar (Reyhitu)]

@V_Roboto_V
Thanks checking this
If i give the column name “Bill Date” its not filtering correctly
Please see below sheet which have previous year and future

[Oozair_Khan]

Hi @thotlamahesh_kumar

Yes, you are getting an error because Date.ParseExact expects a string date value, but you are passing column names directly. You need to extract the actual date values from the Excel file before parsing them.

Solution: Checking if Any Sheet Has Previous or Future Year

You can iterate through all sheets, extract the date column values, and check if any date falls outside the current year. If such a date exists, you can flag that sheet.

[Vinit_Mhatre (BotBuilder)]

HI @thotlamahesh_kumar ,

To filter the “Biweekly Calendar” column based on the previous or future year, you can use the following approach.

Regards,
Vinit Mhatre

[thotlamahesh_kumar (Reyhitu)]

@Vinit_Mhatre
Let me try this one

[Oozair_Khan]

@thotlamahesh_kumar
Try this