Hi,
I think I am being very stupid on this one but just can't see it.
I have a field which is updated when a project is closed with a Date(Date07). So I have a serious of projects with various close dates which is fine. However, I won't to search or the users be able to search on all projects closed in a prompted year.
I have created a calculated field in a BAQ, no format , integer , for the year. But I can't seem to search on it....
I think I am having a dumb moment. Anychance of any help on this.
I think I am being very stupid on this one but just can't see it.
I have a field which is updated when a project is closed with a Date(Date07). So I have a serious of projects with various close dates which is fine. However, I won't to search or the users be able to search on all projects closed in a prompted year.
I have created a calculated field in a BAQ, no format , integer , for the year. But I can't seem to search on it....
I think I am having a dumb moment. Anychance of any help on this.