Date Problem

[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

[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

[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.

[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