Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Result for month (s) ago
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ngaisteve1
Junior Member

Malaysia
241 Posts

Posted - 27 October 2003 :  00:22:36  Show Profile  Send ngaisteve1 an ICQ Message
let's say I have a combo box with value one month, two month and three month. When the user select one month, it means that the user want to see all results a month ago. Eg, if today is 25-Oct. When he selects one month, then all result from 25-Sep to 25-Oct. For now, just forget about the special case like Feb or any special case first. Which date function is best apply for this case?

Thank you for all contribution.

laser
Advanced Member

Australia
3859 Posts

Posted - 27 October 2003 :  00:24:16  Show Profile
Alfred posed a similar question about a week ago or so. Use DateAdd and -30 from memory
Go to Top of Page

ngaisteve1
Junior Member

Malaysia
241 Posts

Posted - 27 October 2003 :  04:20:06  Show Profile  Send ngaisteve1 an ICQ Message
Thank you so much. It helps.
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 27 October 2003 :  08:29:04  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Just use...

DateAdd("n",-30,strForumTimeAdjust)
if your not putting it into the snitz forum then use the following...
DateAdd("n",-30,Now)

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 27 October 2003 :  11:32:35  Show Profile
I thought that you want to use DateAdd("m",-1,originaldate)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07