if {?Approval Date} =  date(1900,1,1) 

then {Command.APPROVAL_DATE} = {?Approval Date}

else

 if {?Approval Date} <> date(1900,1,1)
????????????????????
then

{Command.APPROVAL_DATE} = {?Approval Date}

 

doesn't address the what to do when the date isn't equal to 1/1/1900.  Also, I am always leary of using Command object to retrieve data, as I don't think that is what CR was thinking when they were designed, so I am unsure of what they will return.

 

which records are not being returned?  once you know that, you might see why they aren't, since we have no knowledge of what is to be returned, or what the command looks like.

 

HTH