connection with Labview - timestamp problems

[Bart_S]

Hi,

I have connected Labview 7.1 with FMP8.5 using DataDirect Sequelink 5.4 (ODBC).

The problem is that I cant get a timestamp from Labview to filemaker.

It doesnt even work when i just type "18/04/2007 09:41:32" in a text field in Labview and then copy it to FM. FM always puts it like this

"18/04/2007 09:41:32"

and i have no clue why. Do I have to use a different format in FileMaker or is the problem situated in Labview? Or is it an ODBC problem?

any help is welcome

Bart

[The Shadow]

You might try ISO-time format, and I think DD's driver likes an indicator, try out:

ts'2007-04-18 09:41:31'

to insert into the timestamp field.

[Bart_S]

thx for your help, i tried the ISO-format and now it works fine. I never tried it before because in my language '18-04-2007' is the standard format