Hi,
I want to know that how can i compare current job and expired date from jobs by which if the expired date exceed the job will get hide ??
I am confused can anyone kindly tell me the code for that ?
WHERE CURDATE() <= jobexpiredate
Something like that?
Yup, i have done some how and that query is showing the dates which are <= current date but now i want to hide all the jobs which are expired how can i do that?
How do you know if they are expired?
Through expired date
why am i not totally surprised
The where condition I posted gives you all rows with expiration date >= current date, which should be what you want?
If your current query is showing the rows with expiration date <= current date, then change the operator from < to >