Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number to Date conversion

Status
Not open for further replies.

moteague

Programmer
May 11, 2000
1
0
0
US
I need to convert this number: 932141114 to a real date/time. I am unable to do this with CR built in functions. Help.
 
If the built in functions don't work, have you tried the Left, Mid and Right functions.  Use these functions to extract the year, month, day and time and then convert each to its date/time component. Then concanenate them together.  I hope this works.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top