No kidding. I tried

SELECT * FROM c_tbl WHERE dt_tm >= {^1998/10/27 08:30:00 A}

which worked. But:

SELECT * FROM c_tbl WHERE dt_tm >= {^1998/10/27 08:30:00 A} .AND. dt_tm <= {^1998/10/27 08:30:00 A} 

didn't. So, is it how 5.0 was representing the datetime field in the file?

>And this is directly opposite to the thread from a week or two ago that said the field MUST be on the left to work reliably. Very strange.