search filtering issue

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

search filtering issue

Author

Message

GaryDN

Posts: 34

Posted: 03/12/2009, 4:21 AM

Has anyone see this before. I'm filitering a ms sql database on a date. Date is stored as date/time. If I use the >= I get the proper results (the search date plus everything greater). If I use the <= I only get everything less than the current date.

I tried several different ways and it is always the same. Just wanted to check to see if its me or do I need to report this to Yes

Thanks

Oper

Posts: 1195

Posted: 03/12/2009, 1:37 PM

You know that in the past we ran into this issue and the solution also to make the APP more portable
now where every we add a DateTIme file we Add a DateIndex format
(it is extremely fast like this "20090312163000" for 12-mar-2009 4:30:00 pm

but we keep both field.

maybe not your solution sine i dont know how deep you are into your apliaction.
but is really a good move.

also you can notice that must of teh Forum/CMS/etc that use date value save the datetime
in that format.

but is a personal decition so.

_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first

GaryDN

Posts: 34

Posted: 03/12/2009, 3:23 PM

Oper
how do you convert the date/time to the all number format. It would not be a big deal for me to add a couple of fields to the db if I had to.

Oper

Posts: 1195

Posted: 03/13/2009, 10:33 AM

gary in ASP:

i have a small Function in a Function library like this:

  
Function SerialDateValue(vFecha)  
      SerialDatevalue=CCFormatDate(vFecha,array("yyyy","mm","dd","HH","nn","ss" ))  
End Function

Important: note that the HH are caps.

now just call SerialdateValue(now())
from any part of your program
you cant doint SQL way too.

do a test and let me know before go to deep in your project.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login