Use Date URL Parm in where clause of Grid

CodeCharge Studio

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

Use Date URL Parm in where clause of Grid

Author

Message

WebStudioSC

Posts: 7

Posted: 03/10/2012, 6:50 PM

I'm trying to use a Date URL Parm in my where clause of my Grid. I keep getting this error:

The value in field {my date field} is not valid. Use the following format: ShortDate.

I tried all kinds of date formats, but nothing seems to work.

Has anyone had this issue and does anyone know how I can fix this?

Thanks,
Mitch

clahti2

Posts: 107

Posted: 03/12/2012, 9:49 AM

Quote WebStudioSC:
I'm trying to use a Date URL Parm in my where clause of my Grid. I keep getting this error:

The value in field {my date field} is not valid. Use the following format: ShortDate.

I tried all kinds of date formats, but nothing seems to work.

Has anyone had this issue and does anyone know how I can fix this?

Thanks,
Mitch

Dates can be a pain, you need to make sure the controls for the search and the target fields are set the same way, both in the display format property and the database property. It appears your target control is set to short date, but the search control is something else.

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