Wade Preston Shearer wrote: > > I need to select all the things the user has done within the current > three year window since the date the user's account was created.
> …and we only want the things that were done within the current three > year period. So want to select things they did within three yeas of their create date as well as stuff they've done within three years of today? Or do you mainly just want to select stuff they've done in the past 3 years after they were created? You could do either one really, but if you're only looking for the past three years, and assuming the user couldn't do anything before they were hired, it should be a little simpler. And I can't remember the syntax off the top of my head (it's been about 6 years since I used it regularly), but I think if you look at age type functions (find everyone over the age of 8, for example) you'll be able to piece it out. _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
