Page 1 of 1
Date Problem
Posted: Thu Sep 22, 2005 12:08 pm
by Nancy_(Guest)
I am using version 8.1 and have a date field in an Access database. When I use that field as a filter in R&R, it only sees a date/time field and won^t filter on it. How can I make R&R see it as just a date field? I^ve used up all my ideas.____Thanks,____Nancy
=> RE: Date Problem
Posted: Thu Sep 22, 2005 4:29 pm
by kfleming
You can convert the datetime field to a date field and then filter using this calculation.__One way to get there is:__CTOD(word(DTTOC(dt),1))____this converts the datetime field called dt to a date field.____Kathleen__R&R Support
==> RE: Date Problem
Posted: Fri Sep 23, 2005 9:31 am
by Nancy_Bennett_(Guest)
I would have to go into my database and enter a time for every employment date. I only have a date in the field and the the type of field is "short date." R&R doesn^t recognize it and says it is not a date/time field even though I don^t want a date/time field. ____If I have to I^ll go in and enter times in the field, but that is going to take a lot of time.
===> RE: Date Problem
Posted: Fri Sep 23, 2005 3:17 pm
by kfleming
You don^t need to go back and change anything in your data table.__You just need to create the calculated field in your report and then filter using that calculation rather than the actual table field.____Kathleen__R&R Support