Calculation condition in table box

[shaktisinghchau]

Greetings,

I have a table box where I want to show employees whose has status date in between start and end date variable, I checked all these 3 field has datatype of dates and format is MM/DD/YYYY.

I tried following expression but did not working, my table box is showing data beyond start/end date.

EmployeeStatusDate >= vStartDate and EmployeeStatusDate <= vEndDate

EmployeeStatusDate >= $(=vStartDate) and EmployeeStatusDate <= $(=vEndDate)

[dinuwanbr]

Hi Shakthi,

Can you try following date() or date#()

EmployeeStatusDate >= Date(vStartDate,'MM/DD/YYYY') and EmployeeStatusDate <= Date(vEndDate,'MM/DD/YYYY')

if not working is it possible to upload a sample here?

Rgds,

Tharindu

[shaktisinghchau]

It is not working, thanks for quick response!!

[dinuwanbr]

Hi Shakthi,

Is it possible to upload a sample?

Rgds,

Tharindu

[prieper]

Looks like a formatting problem.

When working with dates, it makes often sense to restrict the comparisons on the pure numbers, rather than trying to workaround with different format-settings.

[shaktisinghchau]

I can not upload qvw it is at client end alos size of the file is huge

[shaktisinghchau]

Thanks Peter but I have tried via number comparison as well but it did not work...

[Peter_Cammaert]

AFAIK a Table Box doesn't offer filtering or expression evaluation capabilities. Except for the object itself...

[prieper]

you are correct, have overlooked this condition from the OP

[Peter_Cammaert]

Usually, Table Boxes can be converted into Straight Tables. And those offer all expression and conditional show tools that you want. The speediest solution would be a straight table with an expression that uses Set Analysis to reduce the number of rows shown...