Our full technical support staff does not monitor this forum. If you need assistance from a member of our staff, please submit your question from the Ask a Question page.


Log in or register to post/reply in the forum.

problem Timestamp format

jobar Jan 10, 2011 02:51 PM

Hi there,
I have a problem with the TimeStamp format.

- When I use DataTable to store a value in the CR1000, the Timestamp format is :"2011-01-10 10:53:00"

- When I program variable = dataTable.TimeStamp the Timestamp format is :"01/10/2011 10:53:00"

anyone ever experienced a similar problem or can give me some solution to this problem?

My CR1000 configuration
OS version : CR1000.std.18
OS date : 091119
OS Signature 4542

Thanks and good year for all

jobar

* Last updated by: jobar on 1/10/2011 @ 8:03 AM *

Skipper Jan 10, 2011 04:12 PM

The TableName.Timestamp(m,n) instruction uses parameters to determine the format of the output. With your variable formatted as a string, use m=4 to get the same timestamp format as the data table uses (CCYY-MM-DD HH:MM:SS.uu).

As a side note, I recommend updating your OS to the latest version, v. 21.

jobar Jan 10, 2011 04:43 PM

It's magic.......

Thank you for your help

Best regards

Jobar

whg573 Jan 17, 2011 06:14 AM

You can get more from these
Time = RAW.TimeStation(4,1) '"ccyy-mm-dd hr:mm:ss
' Time = Raw.TimeStation(1,1) '"mm/dd/yyyy hr:mm:ss
' Time = RAW.TimeStation(3,1) '"dd/mm/yyyy hr:mm:ss

Log in or register to post/reply in the forum.