Users Validity

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rashmitha reddy
    New Member
    • Feb 2007
    • 6

    #1

    Users Validity

    Hi,

    I have a requirement such that i have user details with startdate and end date for a subscription.So now i wanted to find the no.of days b/w these two dates.And should be feasible to find the users whose validity will be expired it should be available for either same month or either before 1Month,3Months. .....and i wanted to execute it in backend .I am using SQL 2000 as backend and ASP.Net with c# as frontend.I would be glad if any one help me at the earliest stage.
  • vijaydiwakar
    Contributor
    • Feb 2007
    • 579

    #2
    Originally posted by rashmitha reddy
    Hi,

    I have a requirement such that i have user details with startdate and end date for a subscription.So now i wanted to find the no.of days b/w these two dates.And should be feasible to find the users whose validity will be expired it should be available for either same month or either before 1Month,3Months. .....and i wanted to execute it in backend .I am using SQL 2000 as backend and ASP.Net with c# as frontend.I would be glad if any one help me at the earliest stage.
    to find date diff. use datediff function

    Comment

    Working...