Reconciliation of new clients

Mark HHP

How could I check any new BOs added between a certain time if they don't have any timestamps attached?

I have this one that checks Calls between 9am and 10am.

FIND Calls WHERE DATE_PART(Calls.TimeOfCall)=DATE_PART(CURRENT_TIMESTAMP) AND HOUR(Calls.TimeOfCall)>=9 AND HOUR(Calls.TimeOfCall)<=10 AND Calls.Consultant.ID=LoggedInConsultant.ID ORDER BY Calls.TimeOfCall

Calls have a start time attached.

But now I want to check any Clients created within that timeframe (and possibly even all day) Basically so that we can keep track of new Clients being managed by our Consultants.

hpl123

One solution is to just add a timestamp attribute that is used for this purpose only and not visible in forms etc. and then use this attribute as a filter.

Mark HHP

Ah, that's what I thought. Was hoping to not have to add anything more but oh well!

Thanks.