OK ....I am sure this one is very simple but here we go
I have a default date set up on a form as now() so each time a new record is entered it brings up todays date.
Tt is set to short date xx/xx/xx with an input mask
My problem is that elsewhere I am running a summary form which includes this field for all records. Although displayed as xx/xx/xx when I click on it, it shows xx/xx/xx and the time.
I therfore am unable to filter by a date. (As it includes the time as well and does not recognise them as the same)
I tried using today() instead of now() but it does not seem to recognise this in the default setting.
Any ideas as to what I am doing wrong?
I have a default date set up on a form as now() so each time a new record is entered it brings up todays date.
Tt is set to short date xx/xx/xx with an input mask
My problem is that elsewhere I am running a summary form which includes this field for all records. Although displayed as xx/xx/xx when I click on it, it shows xx/xx/xx and the time.
I therfore am unable to filter by a date. (As it includes the time as well and does not recognise them as the same)
I tried using today() instead of now() but it does not seem to recognise this in the default setting.
Any ideas as to what I am doing wrong?
