Filter using date

Learn
1

Hi Team,

I am facing issue while filtering data with dates. In attached Excel, i want to filter data for last three months like (start date is 1st jan and end date is 31st march) in column “Time”.and keep that filtered in new Tab.
Note : start and end date are dynamic values

Could you help me to do it

Regards,
SushantTest2.xlsx (60.7 KB)

2

Hi @sshitol Check this.Sequence15.xaml (7.1 KB)

1 Like
3

Its working fine…only one issue…in filter wizard you use |ess than and greater than but i need less than equal to and greater than equal to…
I tried that but its working fine for less than and greater than but for equal to its not giving proper result. Its exclude the start date and end date for equal to.

Regards
Sushant

4

Test2.xlsx (56.7 KB) Sequence15.xaml (10.4 KB)

While comparing date, i have ignored the time portion. Now result looks good. Please have a look.

Thanks! @sshitol

5

Hi,
Still facing same issue. Its not working on = sign. Giving only less than and greater than data

Regards,
Sushant