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!

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

Time format in Focus

Status
Not open for further replies.
TomBorcoman

TomBorcoman

Technical User
Apr 30, 2003
10
US
We have data in the following format:

0953 = 9:53 am

1325 = 1:25 pm

What is the easiest way to convert to a time format? The closest we got has everything but the colon in the proper spot.
 
Sort by date Sort by votes
Check out the subroutine HSETPT, which inserts components into a date-time field.
 
Upvote 0 Downvote
I know I should know this but where would be a good place to get information about subroutine HSETPT????
 
Upvote 0 Downvote
The best place would be the 'Using Functions' manual for your platform.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Jack3d
  • Locked
  • Question
time period drop down
Replies
0
Views
136
Jack3d
Jack3d
NollaunoUK
  • Locked
  • Question
FOCUS Users Locations?
Replies
0
Views
104
NollaunoUK
NollaunoUK
focus393
  • Locked
  • Question
simple focus code giving error 1
Replies
2
Views
171
focus393
focus393
ekl0908
  • Locked
  • Question
Can I create a JOIN which uses two different keys depending on a field in the file?
Replies
0
Views
147
ekl0908
ekl0908
amarg
  • Locked
  • Question
Rounding in webfocus
Replies
2
Views
196
amarg
amarg

Part and Inventory Search

Sponsor

Back
Top