Date Filtering Issue

[kakani87]

Dear All,

I'm having two fields with me like LiveEntryDate and Emp, now my requirement is to display the list of people liveentrydate less than max liveentrydate and this is showing the list exactly.

Max({<LiveTrackEntryDate,EmpName=p({<LiveTrackEntryDate={'>$(=date(max(LiveTrackEntryDate),-1)) <$(=date(max(LiveTrackEntryDate)))'}>})>*<LiveTrackEntryDate,EmpName=e({<LiveTrackEntryDate={'$(=If(getselectedcount(LiveTrackEntryDate),max(LiveTrackEntryDate),max(LiveTrackEntryDate)))'}>})>}LiveTrackEntryDate)

Now the issue is with the filter that when i filter the liveentrydate the data is not populating correctly

i.e lets say if we filter for livedateentry 0n 07/01/2018 this is showing   greater than the date records as well.

can any one help me.

Shared image is with out filtering  correct data and second is filtered show ing wrong .

[Anil_Babu_Samineni]

Could be problem here

Max({<LiveTrackEntryDate,EmpName=p({<LiveTrackEntryDate={'>$(=date(max(LiveTrackEntryDate),-1)) <$(=date(max(LiveTrackEntryDate)))'}>})>*<LiveTrackEntryDate,EmpName=e({<LiveTrackEntryDate={'$(=If(getselectedcount(LiveTrackEntryDate),max(LiveTrackEntryDate),max(LiveTrackEntryDate)))'}>})>}LiveTrackEntryDate)

[kakani87]

Not working Anil