Time Stamp read problem with Spreadsheet String To Array

[Nishant]

Hiii, David

         So how can we overcome that? are you getting perfect time there? here considering that the time is original+5.30.00, i ve minus the time 5:30:00, from original but it is still not working, is this happening bcoz the default time is 5:30:00 AM?

Thanks,

Nishant

[DavidJCrawford]

The time is alright on my screen.

Time here in the UK is 10:58 at time of writing

I am guessing its timezone as I ran into this problem before. I don't know why its different where you are.

These questions pop into my head:-

Has the file I sent you stored the timezone from my location where the file was last saved?

Will recompiling the VI I sent (using CTRL and Run Arrow together) at your location reset the timezone aspect?

Message Edited by David Crawford on 02-03-2006 05:00 AM

[Nishant]

Hiii,

     On my screen it is showing something like this, it is adding 5:30:00AM into the original time. can you tell me ni which time zone you are?

Thanks,

Nishant

[rolfk]

---

@David Crawford wrote:

The time is alright on my screen.

Time here in the UK is 10:58 at time of writing

I am guessing its timezone as I ran into this problem before. I don't know why its different where you are.

These questions pop into my head:-

Has the file I sent you stored the timezone from my location where the file was last saved?

Will recompiling the VI I sent (using CTRL and Run Arrow together) at your location reset the timezone aspect?

Message Edited by David Crawford on 02-03-2006 05:00 AM

---

That is because you are located in the UK that uses GMT (aka UTC). There you have a timezone offset of + 0 hours. If you convert string times into numeric times you have to account for the timezone the string time has been recorded in. LabVIEW internally uses always UTC but uses the current platform timezone setting when formatting absolute time for display.

What you want to do is either to use relative time (if you do not have a specific date to go with it) or use the Date/Time to Seconds function instead that takes care of timezone adjustment (but only if the timezone the time was recorded in is equal to the timezone the VI is running in of course).

Rolf Kalbermatter

Message Edited by rolfk on 02-03-2006 12:22 PM

[DavidJCrawford]

thanks Rolf learned something new today

I didn't know that labview ran on UTC.

cheers

David

[Nishant]

Hiii,

        Finally i ve get it to the time, by adding 6:30:00, i am reaching to the Indian(our) time, bcos, 5:30:00+6:30:00=12:00:00.

          I want to tell you thanks for such a generous reply, i am glad to know the solution. and want to say that i hope that it will plot on the graph.

Thanks,

Nishant

[DavidJCrawford]

So you could do something like this to calibrate out the offset from timezone.

Does that make sense?

David

Message Edited by David Crawford on 02-03-2006 05:30 AM

[Nishant]

Hiii, David

         Can you pleae tell me that what is the time format difference in my file and in the Senper's file, i ve seen senper's data, but dont know the time format. and yes i also have learned today that LV is Running on the GMT, so now i will keep this thing in mind while working with the time. but i am still unsble to plot it onto the graph, can you show me plsss?

Thanks,

Nishant

[rolfk]

---

@David Crawford wrote:

So you could do something like this to calibrate out the offset from timezone.

Does that make sense?

David

Message Edited by David Crawford on 02-03-2006 05:30 AM

---

It is not so simple. Before LabVIEW 7 or 7.1 LabVIEW always used the timezone offset of the current system configuration to adjust between UTC and local time. Since that LabVIEW uses the actual timezone setting for the platform AND date of the timestamp. This may seem like an unimportant issue but think about daylight saving time offset.

So before LabVIEW 7(.1) you got the timeoffset of the current system configuration irrespective of the actual timestamp.
Since then the timeoffset for 1.1.2006 will have in most countries one hour difference to the timeoffset of lets say 6.6.2006. While for your 0:00:00 1.1.1904 you would theoretically get always non-daylight savings time, but a compatiblity hack in LabVIEWs internal timeoffset calculation will get you the old pre 7 LabVIEW behaviour for timestamps prior to around 1970.

Rolf Kalbermatter

[DavidJCrawford]

Nishant

You can see the formats from the data files posted

Senpers format was 06-01-31  15:41:58,7

Nishants format was 01:15:57

Its just data. You can't tell what timezone it is.

Look at examples for building waveform or xy graphs. There should be enough info to get you started. Have a go then post your code if you get stuck.

David