Hi,
I'm trying to generate a list of employees who haven't had a review since Dec 2013.I'm using this expression in my query:
Last review: DLast("[ReviewDate]","[Tbl_OutcomeHistory]")
which brings up the last date the employee had a review.(I tried using DMax but it didn't seem to like dates?)
How do I get it to just show those who haven't had a review since 1st Dec 2014. I thought I could use "<01/12/2014" in the criteria but it returns no values. I've tried to drop the date into the expression but that returns no values.
Any ideas?
Thanks,
Jamie
I'm trying to generate a list of employees who haven't had a review since Dec 2013.I'm using this expression in my query:
Last review: DLast("[ReviewDate]","[Tbl_OutcomeHistory]")
which brings up the last date the employee had a review.(I tried using DMax but it didn't seem to like dates?)
How do I get it to just show those who haven't had a review since 1st Dec 2014. I thought I could use "<01/12/2014" in the criteria but it returns no values. I've tried to drop the date into the expression but that returns no values.
Any ideas?
Thanks,
Jamie