Hi, I am developing a job application system. Below is the job listing that applicant can view. My problem is how to set the job to not out in the list if the current date is not same with the date published? For example, if admin was insert the job post into a form n database and set the published date for the post on 1/12/2016 so on current date the post will not appear in list until meet the publish date. Then, when the job post is meet the end date so it will remove automatically because the job is not available to apply after meet the end date. So, how to do it? I didn’t have any idea. Kindly help me. Thank you.
Below is the database
SELECT TOP 1000 [j_id]
,[j_position]
,[j_category]
,[j_location]
,[j_datepublished]
,[j_dateend]
,[j_requirement]
,[j_keyobjective]
,[j_responsibilities]
,[j_status]
,[c_id]
,[f_id]
,[j_datecreated]
,[j_datemodified]
FROM [easdb].[dbo].[tbl_jobdescription]
Job posting
|
Functional Area
|
Location
|
Company
|
Published Date
|
End Date
|
Senior Programmer
|
ICT
|
Kuala Lumpur
|
Sunrise Ent
|
30/11/2016
|
10/12/2016
|
IT Helpdesk
|
ICT
|
Kedah
|
Plus Sdn Bhd
|
1/1/2017
|
4/3/2017
|