NI Home > Community > NI Discussion Forums

LabVIEW

Reply
Active Participant
Underflow
Posts: 230
0 Kudos

string to timestamp conversion

Hey folks,

I feel like I'm having a mental block on this one...

I need to convert a string week (1-53) and a string year (20[0-9][0-9]) into the month that the week starts in that year. Typing directly into the timestamp control, LabVIEW 7.1 does this admirably. What LV doesn't seem capable of is programmatically converting a string into a timestamp.

The article at:
http://digital.ni.com/public.nsf/3efedde4322fef19862567740067f3cc/f611ba836bf738ee86256ee6006df459?OpenDocument
called "How Can I Programmatically Update a Timestamp Control in LabVIEW?" suggest conversion into a date/time cluster followed by arithmetic. Of course, the date/time cluster doesn't have a "week of the year" entry, so I can't go that way.

Am I stuck tinkering with the left-over offset of seconds from the 53rd week of the last year?

Thanks,

Joe Z.
Active Participant
Chaos
Posts: 245
0 Kudos

Re: string to timestamp conversion

Hmm, try taking the string (some parsing will be needed) and convert everything to seconds. Then, when you have the seconds, send it to the number to time stamp vi located [numeric|conversion]. Might be an easier way but this is what I would do... beuller?
Member
Sheldon_Stokes
Posts: 82
0 Kudos

Re: string to timestamp conversion

Since you are doing weeks, I'm thinking that my julian date utilities may be what you need to convert week to day number and then back to month and day. If you don't come up with a more clever solution, I'll be glad to toss you my date vi's.

Sheldon
Technical geek, engineer, research scientist, biodegradable...
Active Participant
Underflow
Posts: 230

Re: string to timestamp conversion

Thanks for the replies Chaos and Sheldon,

I ended up calculating... well, I'll just show you in attachment. It doesn't really address boundary conditions that might pop up, but it works for the level that I need. If you spot any bad logic in this, yell!

Thanks folks,

Joe Z.
Member
Dave_Kaufman
Posts: 56
0 Kudos

Re: string to timestamp conversion

could you please email me your julian date vi's?

much appreciated.

Dave.

kaufman@nrl.navy.mil
==============================================
David Kaufman
LabVIEW Certified Developer
==============================================
Member
Scott Y
Posts: 192
0 Kudos

Re: string to timestamp conversion

There are several "Julian Date" VIs available as example programs in the NI Developer Zone.
I am not sure if any of these are exactly the ones that Sheldon Stokes suggested, but they should perform the same function for you.

If you take a look at this search you can see the example programs that are available for download.

Scott Y
NI
Active Participant
Underflow
Posts: 230

Re: string to timestamp conversion

Well, since this has become active again...

I found a bug in my attached picture. The year needs to be decremented when the input week is zero.

There, I feel better now :smileyhappy: