CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.

YesSoftware Forums -> CodeCharge Studio -> PHP

 Search by Dates

Print topic Send  topic

Author Message

Posts: 2
Posted: 11/11/2016, 8:58 AM Quote message

Hello, I have been using CodeCharge recently and it seems to me a pretty useful program in many aspects, but until now I had not raised any problem, and is as follows:

I'm trying to do a date range search, I already saw how to do it through the Query where the date is greater than or equal to a date assigned and less equal to the end date, for a moment I thought I was doing something wrong but after Several tests I realized that the date search is not done, or even with only the date field, does not give me any results, in the field date grid, I put the format dd / mm / yyyy, and in the base Of data yyyy / mm / dd, so that the corresponding dates appear, but I do not know if there is any other configuration missing for me to perform the search for dates, I hope someone can help me, Thanks

And sorry if you do not understand I'm using Google Translator since I do not know much English
View profile  Send private message

Posts: 948
Posted: 11/17/2016, 3:15 AM Quote message

It;s a formatting issue. Make sure you specify the right database format and the source format.
View profile  Send private message

Posts: 513
Posted: 12/17/2016, 3:57 AM Quote message

Bit of a late response I know but I go through this all the time.

I have the search date fields formatted as d/m/yyyy and in the query I put the source of the parameters format as dd/mm/yyyy and use yyyy-mm-dd in the database format. But I use parameter in query with single quotes.

WHERE pay_date ='s_fromdate'

Also works with BETWEEN.

If you are having trouble set the debug flag to 1 in db_mysqli.php and publish just that file. It will display all queries and make it easier to track down the problem


CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia
View profile  Send private message

Add new topic Reply to topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

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