VbVoice interprets the date from access incorrectly?

Hi all,

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.

Thoughts.
jnhgustinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

deightonprogCommented:
does the datafind control use a sql string?  if so you could use the format command on the date field in the sql string
0
jnhgustinAuthor Commented:
I have tried using an SQL String in the DataFind. I actually tested by cutting the string right out of the log. It looked like:
>SELECT [StartDate] FROM [MyTable]
The > is the key to using your own statement.
I tried adding a CONVERT function or a to_char function to this statement. But I just get an error every time. It seems as if I modify the statement at all, it doesn't like it.
0
jnhgustinAuthor Commented:
Well,

I guess there is no more input - I worked around the problem by setting up a "Transfer" variable and upon exiting the DataFind control, using the "exit" routine to populate the transfer variable with a correctly formatted date.

Thanks for the input.

-- This question should be closed.
0
DanRollinsCommented:
Hi jnhgustin,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Refund points and save as a 0-pt PAQ.

jnhgustin, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
NetminderCommented:
Per recommendation, points refunded and question closed.

Netminder
EE Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.