Member Avatar for auwi987

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 because: n/a
  • 2 Contributors
  • 3 Replies
  • 114 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

You need to subtract the dates. Try to use DateDiff Function.

Member Avatar for auwi987

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 because: n/a
Member Avatar for debasisdas

Please read more here.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.