Hi All,
I have a query which produces the following results:
What I want to do is add a column that for all the "Holiday" records, it returns a count of the number of "Not Holiday" records in the results which have a BelongsToDate which falls between the BelongsToDate and the Plus2Weeks date.
The desired results would look like the below:
Any help would be appreciated
Thanks
Tom