please try this:
repeat the thing you did here - Shift=? ... CDCPPMLogDate ≥ ?
ExecuteSQL ( $sql ; ""; ""; field1; field2; etc. )
Thanks for the help!!! But I ended up figuring it out...my Sql was
correct...problem was that execute SQL would not recognize the "≥" I had to
type it as ">="...
Thanks for the help!!!
ah, I wish FM didn't allow the ≥. It's not normal, to me. Same with ≠, as opposed to <>.
1 of 1 people found this helpful
If you want to add parameter,
AND CDCPPMLogDate ≥ ?"; "" ; "" ;CDCAssociates::Global; CDCAssociates::SearchStartDate);
(but your if states Global=1, then 1st parameter can be embedded as Shift=1)