Jump to content

Reformatting existing data in time field


This topic is 5653 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have about 60,000 records in a database that have a time field that i need reformatted. The problem I need to rectify is that even though the fields in question are already time fields they have been set to "leave data formatted as entered". What I need is for the format to be HH:MM. Can anyone suggest a simple way of inserting the : into the existing data fields via script or calculation. Im drawing a blank here. Any help would be greatly appreciated. Thanks, Ron

Link to comment
Share on other sites

It depends on how the times are formatted now...

Is there anyway you could send part of your file?

I'm thinking you can do something like:

Left(TimeField; 2) & ":" & Middle(TimeField; 3; 2) but I'd have to see the formatting of the data.

Either way, I would recommend setting up a calculation field for testing to see waht the result would be, and then you can use Replace Field Contents to clean up the actual Time field.

Link to comment
Share on other sites

This doesn't make much sense, I'm afraid. If the field is a time field, and the entry is valid time, you can format the display by entering Layout mode, selecting the field, and choosing Format > Time... from the menu.

If this doesn't help, then the entry is not valid time and the problem is not how to format it - but how to turn it into a valid entry.

Link to comment
Share on other sites

This topic is 5653 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.