RickK Posted July 17, 2001 Share Posted July 17, 2001 How do I default (declare) a time field value to be a greater (future)value than the previous time field used in a record (twenty time fields in this record)? The problem occurs when user's time passes through midnight (Field 1 at 8:00 PM and field 2 at 4:00 AM) This produces a numerical value in the negative range (-57,600 rather than 28,800), the calculation is looking back rather than ahead regardless of the AM/PM suffix or a 24 hour clock entry. The current solution for one field (One_Time) is: If(One_Time = 0,0, If(Two_Time <= 0 and End_Time > 0, End_Time - One_Time, If(Two_Time = 0 and End_Time = 0, Current_Time - One_Time,Two_Time - One_Time))) Any suggestions appreciated Thx Link to comment Share on other sites More sharing options...
Chuck Posted July 17, 2001 Share Posted July 17, 2001 Try this: code: Case( Link to comment Share on other sites More sharing options...
RickK Posted July 17, 2001 Author Share Posted July 17, 2001 quote: Originally posted by Chuck: Try this: code: Case( Link to comment Share on other sites More sharing options...
RickK Posted July 17, 2001 Author Share Posted July 17, 2001 quote: Originally posted by Chuck: Try this: code: Case( Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8340 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 accountSign in
Already have an account? Sign in here.
Sign In Now