CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> Archive -> GotoCode Archive

 Date part

Print topic Send  topic

Author Message
Janka
Posted: 08/14/2003, 6:00 AM

Hi,

I am using CCS 2.1.

Right now I am using Table parameter where Conditions is:
date equals(=) date()
database shows only current year, month, day records but I need to see all where month and day is equal today not year.

Can someone help please,

Janka
Janka
Posted: 08/14/2003, 7:13 AM

All is working perfect if using expression in table parameter:

Query = "SELECT * FROM Table WHERE MONTH(DateField) = Month(date()) AND DAY(DateField) = Day(Date())

Janka
No help needed anymore:) Stupid me...

   


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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.