Converting column of Dates

[LED47]

I want to extract the DD/MM/YYYY from the excel file attached into LabVIEW

The example I attach uses variant- however I'm open to using anything- I merely want to convert a date form which I can use as an X axis for my graphs.

[ZYOng]

Followed Converting Excel Date/Time Values to DIAdem and LabVIEW Values but not sure why it is off by four hours or a day.

[GerdW]

Hi,

---

@ZYOng wrote:

not sure why it is off by four hours or a day.

---

Timezone settings may apply…

[paul_a_cardinale]

---

@ZYOng wrote:

Followed Converting Excel Date/Time Values to DIAdem and LabVIEW Values but not sure why it is off by four hours or a day.

---

Note: The For Loop is unnecessary:

Same:

[LED47]

Thank you very much, very kind of you know show me that..

I was wondering if I could impose upon you folks once more..

I've attached the same excel spreadsheet but I've added an extra column for Y axis data would you be kind enough to modify the same VI and include an XY display where the X axis is the date?

It's probably trivial but that's where I'm struggling 

[GerdW]

Hi LED,

---

@LED47 wrote:

I've attached the same excel spreadsheet but I've added an extra column for Y axis data would you be kind enough to modify the same VI and include an XY display where the X axis is the date?

---

1. Convert the first column to timestamps.
2. Convert the 2nd column to an array of DBL.
3. Use Bundle to create a cluster of [timestamp array, DBL array].
4. Wire that cluster to a XY graph…

What have you tried and where are you stuck?

[LED47]

Everything's going fine as far as adding the timestamped X axis

I almost feel embarrassed to ask this now but if you could turn me on to one more thing I would very much appreciate it.

I want to be able to display multiple graphs in either XY graph or waveform chart maintaining the X axis time in either case.

[GerdW]

Hi LED,

---

@LED47 wrote:

I want to be able to display multiple graphs in either XY graph or waveform chart maintaining the X axis time in either case.

---

When you want to plot mot than one plot in your graph then you should create an array of plots…

[Bob_Schor]

The LabVIEW Help system is (or, "used to be" -- I'm currently using LabVIEW 2019) pretty complete.  If you look up Graphs and Charts, it discusses how to plot multiple "channels" (it's pretty straight-forward).  There are also multiple Tutorial materials available, including links on the first page of this Forum, and the Web.

You can "look it up" ...

Bob Schor

[LED47]

okay thank you   🙂