January 7, 20215 yr Hi All, As per mentioned on topic, in fact i would like to create icon ex. hour in case rigging guard the insert time.
January 7, 20215 yr I don't understand your question. When you insert the current time, you always insert the computer's current time. There will never be a difference. And once you have inserted the current time into a field, it will become different from the current time in one second or less.
January 7, 20215 yr Author 10 minutes ago, comment said: I don't understand your question. When you insert the current time, you always insert the computer's current time. There will never be a difference. And once you have inserted the current time into a field, it will become different from the current time in one second or less. I meaning the guard in security room put time by manual. Have any method shown like hand different time between current time and insert time by manual. Or if you have any technuiq please provide us. I hope now understand my issue.
January 7, 20215 yr If you want them to enter the current time, why not give them a button that does that, instead of having them enter the time manually? If they must enter the time manually, you could have another field auto-enter the difference between the current time and the entered time. Then if the difference is larger than a few minutes, you could show your icon. Note that the calculation can be more difficult if one of the times is before midnight. Edited January 7, 20215 yr by comment
January 8, 20215 yr Author Yes,should be manually if you can provide the calculation I will be appropriate it ...
January 8, 20215 yr The field could simply auto-enter = Get ( CurrentTime ) - Time In Then you can decide on what's a reasonable window of difference - say 5 minutes - and hide the icon when: Difference < Time ( 0 ; 5 ; 0 ) However, as I already noted, if you can have a situation where the current time is after midnight and they enter a time before midnight, this will not work as expected. I am surprised to see that your form does not have a date; if it did, you could use a timestamp to calculate the correct difference even across midnight.
Create an account or sign in to comment