0

hello guys i have a database with tblblabla and column agent_id, name, regis_date, expire_date

agent_id , name , regis_date , expire_date-->COLUMN HEADER
BLA-1 , SAMPLE , 1/1/2012 , 1/1/2013-->COLUMN DATA

and i have a notification-form that check either the agent is expire or not if the agent is expire it will display to this form if not it will not

the main problem is i can check it by comparing the expire_date to present data, what if the expire_date compared with present date up to the future date, what i mean is how can i let the agent stay on the notification-form, agent will be remove when the expire_date is change
sorry for very poor explanation i hope you'll understand it, thnx in advance

Edited by auwi987: n/a

2
Contributors
3
Replies
4
Views
5 Years
Discussion Span
Last Post by debasisdas
0

thnx debasisdas but can you show me how to use datediff function? is it apply on sql query?
pls let me see some samples, thnx again

Edited by auwi987: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.