BETWEEN
emplTab.NAT_PayEmloymentDate==str2date(s,123) and emplTab.NAT_PayEmloymentDate==str2date(s1,123)