>>>Steve,
>>>
>>>If you could show us your code that errors on you it would be much easier to help you out.
>>>
>>>Keep in mind that teh delimiters for date and datetime values are the curly braces {}. So to replace a datetime field named Today with a blank would be;
>>>
>>>REPLACE Today WITH {}
>>
>>Technically, shouldn't that be {//:} so that its an empty DATETIME type? For a variable, setting it to {} would make it a DATE type (D), not a DATETIME type (T).
>
>Using a datetime field in a table replace field with {} works just fine.
I just tried that and you are correct. You can also replace a date type field with a datetime value and it accepts that too. Live and learn. Thanks. I guess you only have to be careful when dealing with variables to make sure they remain the proper type.