I have created a database where a person will put in an expiration date. I also have it where an administrator will set a status for each item entered. Now I want a view where I show data with a set status and before the expiration date.
I tried this line
From `data` where (status='pending sold' or status='pending buy' or status='pending sell') and ('gexpiredate'>@now)
I get no records found and there should be two that show up.
I know this works for the status: From `data` where (status='pending sold' or status='pending buy' or status='pending sell')
It is the date thing I am having a problem with.
Any suggestions?
Kim