D
DJ Notion via AccessMonster.com
I have a form that filters between two dates and need it to work with a text
field that I have made look like a date. The text field is in a linked table
that I can't change the field type.
The linked table has a field called CollectionDate that is 14 digits in the
order by year, month, day, hours, minutes, seconds and displays as
yyyymmddhhmmss. On another form I have an unbound text box with the
following as the control source: =Mid([CollectionDate],5,4) & "2008".
This makes the CollectionDate look like 00/00/0000. I don't need the time at
all. The problem is that it isn't really a date and when I try to filter it
it doesn't work. As a side note, the form that actually filters the dates
works beautifully with other databases so no changes need to be made to the
code I am using; the reason why I haven't provided it. I just need to
manipulate this CollectionDate text field that is creating the problem.
Is there someway I can filter the CollectionDate text field between two dates
or do I need to convert it to a date and then filter. If so, how can I
accomplish that? Any help is appreciated. Thanks.
field that I have made look like a date. The text field is in a linked table
that I can't change the field type.
The linked table has a field called CollectionDate that is 14 digits in the
order by year, month, day, hours, minutes, seconds and displays as
yyyymmddhhmmss. On another form I have an unbound text box with the
following as the control source: =Mid([CollectionDate],5,4) & "2008".
This makes the CollectionDate look like 00/00/0000. I don't need the time at
all. The problem is that it isn't really a date and when I try to filter it
it doesn't work. As a side note, the form that actually filters the dates
works beautifully with other databases so no changes need to be made to the
code I am using; the reason why I haven't provided it. I just need to
manipulate this CollectionDate text field that is creating the problem.
Is there someway I can filter the CollectionDate text field between two dates
or do I need to convert it to a date and then filter. If so, how can I
accomplish that? Any help is appreciated. Thanks.