Filter the date in excel

[Harish_pavuluri]

Hi to all,

I am unable to get the date in excel, The format like (dd/mm/yyy) is looking for 01/01/2021 but my excel is having like 1 jan 2021. hear the screenshot.
Plz suggest me to out of this.
Thks to all.

[elina]

@Harish_pavuluri
Can you please the filter you have used in the code to suggest.

[Harish_pavuluri]

look in to screen shot.

[elina]

@Harish_pavuluri
Please find the code in below screenshot and try. Let me know if it works for your inputs

[Harish_pavuluri]

Thks for reply,

It is showing empty sheet.

[elina]

@Harish_pavuluri
Check your input in the excel and tweek the filter based on it to get the desired output

[NIVED_NAMBIAR (NIVED N)]

Hi @Harish_pavuluri

try this

Hope it helps

Regards

Nived N

Happy Automation

[Harish_pavuluri]

Thks u
There is no change. again it is showing empty sheet.

[NIVED_NAMBIAR (NIVED N)]

Hi @Harish_pavuluri

Can u provide the sample excel sheet for checking?

[Harish_pavuluri]

@ elina thks

It worked after i changed the different input and output data tables in filter.