stealth162 Posted January 21, 2005 Share Posted January 21, 2005 I recently converted my database which is fairly simple to version 7. It has been working fine in version 5 and now I am having trouble with a time field. I use the time fields for calculations of timecode. The fields having trouble function like this. I enter a start time in the format hh:mm:ss and a end time in the same format. The database then calculates the difference between the two and displays it in another field (ie;length) in the same format hh:mm:ss. Now that I have upgraded to version 7 that no longer works. I put in a start time and recieve a format error saying that the time is entered incorrectly. Same goes for the end time. Then when both numbers are in (start and end) the duration field reads some looks to be random number. Here's an example of what version 5 does. start 01:00:00 end 02:00:00 duration = 01:00:00 Here's an example of what version 7 does. start 01:00:00 end 02:00:00 duration=10000:00 Any help is appreciated. I am willing to send the file to anyone that might be willing to take a look. Picture1.pdf Link to comment Share on other sites More sharing options...
This topic is 6636 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
Already have an account? Sign in here.Sign In Now