I have a embedded browse that contains the following fields.
User - character field
Description - character field
Date - date field
Time - time field
I have set up a field rule for the date to be automatically filled in and it works fine. Simple default expression - date().
I tried to do this with the time field using - time() but got an error 0. I have tried various functions which return this same error which I believe is to do with the wrong data type. The now() works but this results in the date and time being shown.
I have read through a number of posts (about 30) but cannot find a solution but there definitely seems to be a lot of confusion. I have looked at the help file but it left me even more confused. To me it seems it should be simple. You have a time field and should have a function that puts the time into it (not the date). I tried changing the field to short time but that didn't help. Some of the posts suggested using a character field and then converting to time. The downside to this if I have understood the posts correctly is that after a global update all the times will be reset to the current time. This would be a problem.
I am hoping someone can throw some light on how to use field rules to put the current time into a field.
User - character field
Description - character field
Date - date field
Time - time field
I have set up a field rule for the date to be automatically filled in and it works fine. Simple default expression - date().
I tried to do this with the time field using - time() but got an error 0. I have tried various functions which return this same error which I believe is to do with the wrong data type. The now() works but this results in the date and time being shown.
I have read through a number of posts (about 30) but cannot find a solution but there definitely seems to be a lot of confusion. I have looked at the help file but it left me even more confused. To me it seems it should be simple. You have a time field and should have a function that puts the time into it (not the date). I tried changing the field to short time but that didn't help. Some of the posts suggested using a character field and then converting to time. The downside to this if I have understood the posts correctly is that after a global update all the times will be reset to the current time. This would be a problem.
I am hoping someone can throw some light on how to use field rules to put the current time into a field.
Comment