Ok - I've been searching, but not finding, so I'll put it out there, and maybe one of you talented folks can give me the simple answer that's been eluding me all afternoon...
I need to pull all the records from my db of students over the age of 25. I thought perhaps I could use a simple < or > expression with a date, but that doesn't seem to be doing the trick.
The date field is in short format, dd/mm/yy, but the input mask for some reason is dd/mm/yyyy (don't ask me, I didn't create the db, just inherited it...).
What is the short, simple expression I would put in the criteria of my query that will pull only those dates earlier than 03/16/1980?
Thanks in advance!
I need to pull all the records from my db of students over the age of 25. I thought perhaps I could use a simple < or > expression with a date, but that doesn't seem to be doing the trick.
The date field is in short format, dd/mm/yy, but the input mask for some reason is dd/mm/yyyy (don't ask me, I didn't create the db, just inherited it...).
What is the short, simple expression I would put in the criteria of my query that will pull only those dates earlier than 03/16/1980?
Thanks in advance!
