In PAD Excel instance Filter ,not able to filter a column with equal to one specific date.

(1) Share

Report

Posted on by Kevin Jiang

It is ok to filter great than or less than and even great or equal to one date ,but when you set the filter condition as equal to one specific date like '2024.05.08',it will only pops up the date value not date on excel like '45451' which

will cause the filter action not work.

Categories:

Process Advisor

I have the same question (0)

All responses (2)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

In PAD Excel instance Filter ,not able to filter a column with equal to one specific date.

Hi @CU26120345-0

Does the date in excel is like number 45451 ?

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
Verified answer

kinuasa 795 Most Valuable Professional on at

Like (1)

Report

In PAD Excel instance Filter ,not able to filter a column with equal to one specific date.

Try turning off the "Advanced" option under "Filters to apply".

Was this reply helpful? Yes No