E
eren_greenlady
Guest
i trying to write a code to display an announcement in spesific date of range.. but i could not find way to do it. the query is like this..
SELECT * FROM tbl_Anoucement WHERE (((ale_Shown)=Yes) AND ((ale_StartDate)>=Date()) AND (Not (tbl_Anoucement.ale_EndDate)=Date())) ORDER BY ale_id DESC
when the startdate come then the announcement will be display until the enddate.. after the range date end, the announcement will no longer displayed. Before the start date also it will not display the announcement.. can anybody help me with this. My query did not help me. it only display when the startdate come.
i'v tried colanth way but still is not working.. do i have to write any function?
SELECT * FROM tbl_Anoucement WHERE (((ale_Shown)=Yes) AND ((ale_StartDate)>=Date()) AND (Not (tbl_Anoucement.ale_EndDate)=Date())) ORDER BY ale_id DESC
when the startdate come then the announcement will be display until the enddate.. after the range date end, the announcement will no longer displayed. Before the start date also it will not display the announcement.. can anybody help me with this. My query did not help me. it only display when the startdate come.
i'v tried colanth way but still is not working.. do i have to write any function?