>I am using Oracle as a backend with SQL pass thru.
>When you do this all date fields are automatically datetime.
>
>Is there any easy way I can remove the "time" portion in selected text boxes
>so the user does not need to see and enter this part.
>
>I saw SET SECONDS OFF which removes the seconds. But I'm looking for a SET TIME OFF or inputmask expression that can do this..
>
>BR
>Tim
Tim,
As I read you're using VFP8. Then use CursorAdapter. Set datatype to Date in cursorschema and instruct CursorFill to use the schema (1st parameter true).
PS: For a sample with SQL server check Thread #
940852Cetin