Convert Time Stamp to String

[Eric1977]

What is the most efficienct way to convert a Time Stamp Control to a MM/DD/YYYY string? I am going to use its output as date parameters to a WHERE clause to a SQL Server query.

[dan_u · Accepted solution]

Format Date/Time String is a simple option.

[Eric1977]

I skipped right by that. I must not have had enough coffee yet this morning.

Thank you.

[dan_u]

You're welcome 

[JÞB]

Those format codes can be tricky to write from scratch. I usually format a timestamp constant the way I want it displayed, switch to advanced format editing and copy the format string.

[Eric1977]

Jeff,

I just did it like this. Do you forsee any problems? I noticed yours had the greater than and less than math operators near the beginning and end of the format string.

[smercurio_fc]

---

@Eric1977 wrote:

Jeff,

I just did it like this. Do you forsee any problems?

---

Well, what is the output? Do you foresee a problem? The LabVIEW Help is quite clear on the format. The very first sentence of the Help file for the Format Date Time String provide a link to the codes: https://www.ni.com/docs/en-US/bundle/labview-api-ref/page/vi-lib/string/format-codes-for-the-time-fo...