I am using VbVoice from Pronexus. I use the DataFind control to lookup data in an access database, one field of which is a datetime field. Then I use a PlayGreeting control to play the date. The log shows an error that it can't interpret the data and it shows the date in the format "mm-dd-yyyy". VbVoice wants the format to be "mm/dd/yyyy". So it bombs. I'm using the ODBC driver with a DSN for access.
Is there a different driver I need to use?
I can override the DataFind control and put in SQL. But it doesn't seem to accept everything. If I use a to_char function or a convert function it does not accept it. Is there something else I can do with the SQL.
Lastly, I could skip the DataFind control and go to the code level to pull the date out of the database and format it correctly, but then how can I put the data back into a control field that the Play Greeting will recognize. I would like to avoid putting the Play Greeting in the code too.