Good morning. I seem to be having a little difficulty converting a string into a timestamp. I'm good in all of the places I need to do this conversion but 1. The date I'm being fed is of the form 20-MAY-18. I connected this to a scan from string with the %d-%s-%d, but the %s is coming back as MAY-18 and the last number is coming up as 0. I thought maybe it had something to do with my delimiters, so I changed them to / instead of -, but it's still giving me MAY/18. Any one have any suggestions on how to get this to cooperate??? Am I doing something wrong???

Actually Bob, if you replace the format string with %<%d-%B-%y>T then the required format "20-May-18" is converted perfectly !! Nice one.

Once I figured out how to use Scan from String, I use it for all of my "Scan from String" problems. You have a string, "20 May 2018", and you want to convert it to a TimeStamp. Drop down a Scan from String, wire "20 MAY 2018" into the String Input, and wire a TimeStamp constant into the Default Value 1 slot. Be sure to wire Error Out to allow the function to warn you when you try to convert "20 Mabel 2018" ... Now the only thing missing is the Format String, which (by default) is "%T", i.e. the generic Absolute Time format. But you have a specific Time format -- a "day of month" (%d) separated by a space from a "Full Month Name" (%B), though this might also be an "Abbreviated Month Name" (%b), again separated by a space from a 4-digit year (%Y). This expanded Format String is written %<%d %B %Y>T and is shown in this Snippet: If there is more before or after this String, just add appropriate default Input types and expand the Format String to match. If the TimeStamp also includes Time, the appropriate format specifications for them can be placed inside the Format String illustrated above. To see the (bewildering) list of TimeStamp Formats, search Help for "Format Codes for the Time Format String". Bob Schor

The "%s" format specifier will match any non-whitespace characters, including a dash or slash, and only stops when it reaches a whitespace character. If you want to limit it to only matching capital letters, you can use "%[A-Z]", then it will stop when it reaches the dash or slash.

Return to Home Page
Toggle navigation

Solutions

Industries

Academic and Research
Aerospace, Defense, and Government
Electronics
Energy
Industrial Machinery
Life Sciences
Semiconductor
Transportation

Product Life Cycles

Design and Prototype
Validation
Production

Focus Areas

5G and 6G Technology
ADAS and Autonomous Driving Testing
Electric Vehicle Test
Lifecycle Analytics
Radar and Electronic Warfare
Space Launch and Exploration
Validation Lab Innovations

See our approach to solutions

Get a Helping Hand

From troubleshooting technical issues and product recommendations, to quotes and orders, we’re here to help.

Products

Software

View All Software

LabVIEW
TestStand
FlexLogger
SystemLink
DIAdem
VeriStand
OptimalPlus GO

Software Suites

LabVIEW+ Suite
HIL and Real-Time Software Suite
Circuit Design Suite

SERVICES

View All Services

Repair Services
Calibration
Training Courses

HARDWARE

View All Hardware

Data Acquisition and Control

Learn About DAQ
CompactDAQ Bundles
Multifunction I/O
Voltage
Digital I/O
Temperature
Sound and Vibration
Current
Strain, Pressure, and Force
CompactDAQ Chassis

Electronic Test and Instrumentation
PXI Instrument Bundles
GPIB, Serial, and Ethernet
Switches
Oscilloscopes
Digital Multimeters
Source Measurement Units and LCR Meters

Wireless Design and Test

Software Defined Radios
RF Signal Generators
Vector Signal Transceivers

Application-Specific Systems

Semiconductor Test System
Power Electronics Test Systems

Accessories

Power Accessories
Connectors
Cables
Sensors

FEATURES

Entry-Level DAQ

RESOURCES

Advisors
Distributors

See all products

PC-Based Systems

Benchtop Measurement and Test

CompactRIO

Distributed Measurement and Control

PXI

High-Performance Test

Software

Systems Engineering Software

Perspectives

Perspectives showcases how NI sees what’s next in the world of test and technology.

View all articles

Charting the Course for Test Development with LabVIEW

LabVIEW remains key in test, promising speed, efficiency, and new features with NI’s investment in core tech, community, and integration.

Read our featured article

Support

Resources

View All Support Resources

Software Downloads
Register and Activate
Product Documentation
Release Notes
Online Training
KnowledgeBase
Code Examples

Request Support

You can request repair, RMA, schedule calibration, or get technical support. A valid service agreement may be required.

Open a service request

Popular Software Downloads

See all Software Product Downloads

LabVIEW

Multisim

Academic Volume License

Popular Driver Downloads

See all Driver Software Downloads

NI-DAQmx
Provides support for NI data acquisition and signal conditioning devices. 
NI-VISA
Provides support for Ethernet, GPIB, serial, USB, and other types of instruments. 
NI-488.2
Provides support for NI GPIB controllers and NI embedded controllers with GPIB ports.

Community

About

My Account

Account

Cart

Solutions
- Back
- Industries
- Academic and Research
- Aerospace, Defense, and Government
- Electronics
- Energy
- Industrial Machinery
- Life Sciences
- Semiconductor
- Transportation
- Product Life Cycles
- Design and Prototype
- Validation
- Production
- Focus Areas
- 5G and 6G Technology
- ADAS and Autonomous Driving Testing
- Electric Vehicle Test
- Lifecycle Analytics
- Radar and Electronic Warfare
- Space Launch and Exploration
- Validation Lab Innovations
- See our approach to solutions
Products
- Back
- Software
- View All Software
- LabVIEW
- TestStand
- FlexLogger
- SystemLink
- DIAdem
- VeriStand
- OptimalPlus GO
- Software Suites
- LabVIEW+ Suite
- HIL and Real-Time Software Suite
- Circuit Design Suite
- SERVICES
- View All Services
- Repair Services
- Calibration
- Training Courses
- HARDWARE
- View All Hardware
- Data Acquisition and Control
- Learn About DAQ
- CompactDAQ Bundles
- Multifunction I/O
- Voltage
- Digital I/O
- Temperature
- Sound and Vibration
- Current
- Strain, Pressure, and Force
- CompactDAQ Chassis
- Electronic Test and Instrumentation
- PXI Instrument Bundles
- GPIB, Serial, and Ethernet
- Switches
- Oscilloscopes
- Digital Multimeters
- Source Measurement Units and LCR Meters
- Wireless Design and Test
- Software Defined Radios
- RF Signal Generators
- Vector Signal Transceivers
- Accessories
- Power Accessories
- Connectors
- Cables
- Sensors
- FEATURES
- Entry-Level DAQ
- RESOURCES
- Advisors
- Distributors
- See all products
Perspectives
Support
- Back
- Resources
- View All Support Resources
- Software Downloads
- Register and Activate
- Product Documentation
- Release Notes
- Online Training
- KnowledgeBase
- Code Examples
- Popular Software Downloads
- See all Software Product Downloads
- LabVIEW
- Multisim
- Academic Volume License
- Popular Driver Downloads
- See all Driver Software Downloads
- NI-DAQmx
- NI-VISA
- NI-488.2
- Request Support
- You can request repair, RMA, schedule calibration, or get technical support. A valid service agreement may be required. Open a service request
Community
About
Contact Us
Account