hi

Instead of writing SQL Expressions better go for a Add command

Sample code would be :

Select status, Hiredate,Termdate,rehiredate from einfo where Status <>Previous(status)

now you also select tables which are required to generate report but do not link above Add command field with your table field.  You need to use this dates for only filtering purpose.