Sorry, I should have given some more information about the problem...
The report returns information based on a single unjoined table - called TableA for this purpose.
TableA contains 2 date fields:
StartDate
EndDate
The actual type of this fields is DateTime, i.e. dd/mm/yyyy hh:mm:ss
TableB...
I'm writing a function that does some calculations on dates, and need to check if a particular date has a matching date record in another unrelated table.
A pseudo-code description of what I'd like to do...
for Date := Start to Finish
Check := recordexists(key=Date) in TableB
if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.