SQL & Dates...

Results 1 to 2 of 2

Thread: SQL & Dates...

  1. #1
    Join Date
    Dec 1969

    Default SQL & Dates...

    I have this simple SQL:<BR>SQL = "SELECT id,name FROM usersTBL ORDER BY name"<BR><BR>The thing is that I want to select only the users their membership is still ON (membershipEndDate).<BR><BR>How can I do it?

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL & Dates...

    What database?<BR><BR>sql server<BR><BR>Where membershipEndDate &#060; GetDate()<BR><BR>Access<BR>Where membershipEndDate &#060; Now()<BR><BR>Might want to look into the faq&#039;s about working with dates in general...<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts