Snitz Forums 2000 - SQL on Date, using Snitz date format

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 DEV-Group

DEV Discussions (General)

SQL on Date, using Snitz date format

New Topic

Topic Locked

Printer Friendly

Author

Topic

CarKnee
Junior Member

USA
297 Posts

Posted - 13 December 2002 : 11:34:18

Since the M_date field in the FOrum_members table is a text field in the form of yyyymmddhhnnss is there any way to do something like this:

pastdate = Request("pastdate")
today = date()

SELECT * FROM Forum_members WHERE M_Date BETWEEN '" & pastdate & "' AND '" & today & "'"

I am really trying to get all members in between a certain date range, which will change, so I cant hard code the SQL.

Thanks,
Carknee

@tomic
Senior Member

USA
1790 Posts

Posted - 13 December 2002 : 11:58:39

Assuming pastdate is in Snitz's date format:

SELECT * FROM Forum_members WHERE M_Date BETWEEN '" & pastdate & "' AND '" & DateToStr(today) & "'"

@tomic

SportsBettingAcumen.com