Convert string to timestamp

[RTSLVU]

I want to store calibration dates in a file so they can be checked to the current date and notify the user if any of the equipment is out of calibration.

What would be the easiest way to accomplish this?

Using scan fomr string I have been able to change the date string (MM/DD/YY) to numbers, but how do I turn them into a timestamp?

[Eric1977 · Accepted solution]

Look here (if you have hours, minutes, and seconds along with a date):

http://digital.ni.com/public.nsf/allkb/95D386A68269A53A86257082001DAED0

[James.M]

Check out the documentation on the Format DateTime String function. You can format a string to and from a timestamp datatype using %<>T or %<>t

Eric, that cluster manipulation is overkill just to go from string to timestamp and back.

[Hooovahh]

I'd really recommend you use the ISO standard for time.  You can use the Scan From String, and Format Into String to go to and from a timestamp.

https://lavag.org/topic/15034-timestamp-support-for-format-into-string-scan-variant-from-string-stri...

[James.M]

From Hooovahh's link, this is what you want:

[Eric1977]

James - I've always used that function to do conversions (only because I didn't know better). I learned something today, plus it's probably WAY faster.

[RTSLVU]

---

@Eric1977 wrote:

Look here (if you have hours, minutes, and seconds along with a date):

http://digital.ni.com/public.nsf/allkb/95D386A68269A53A86257082001DAED0

---

This seems like a simpler solution.

[James.M]

It's not a simpler solution... It may be an easier solution to understand because it breaks everything down in to a cluster of info, but the overhead (and space) taken up by that is much larger. You should really get comfortable with string formatting and conversion using the single string scan VIs from the other posts above.

[RTSLVU]

---

@James.M wrote:

It's not a simpler solution... It may be an easier solution to understand because it breaks everything down in to a cluster of info, but the overhead (and space) taken up by that is much larger. You should really get comfortable with string formatting and conversion using the single string scan VIs from the other posts above.

---

I don't understand the other proposed sultions at all and can not figure out how to apply them to my situation.

I can not even figure out how to get your snippet into a block diagram without it just being a picture.

[Hooovahh]

It literally is two primatives and a string constant.  Here is the VI.