Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting Text to DateTime
Message
From
31/08/2008 09:17:36
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Converting Text to DateTime
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01343615
Message ID:
01343615
Views:
61
Date = "080810"
Time = "1619"
How can I get a valid DateTime() out of this? Do I have to parse it apart into the year, month and day first? Seems like I have used an easier way with TRANSFORM or something, but can't find it now.

UPDATE: Nevermind. If I had just taken 2 more minutes of searching:

cDateTime = cDate + ' ' + cTime
?cDateTime
? ctot(transform(cDateTime,'@R ^99/99/99T99:99:99'))
Next
Reply
Map
View

Click here to load this message in the networking platform