[Solved] Date Formats on update incorrect

CodeCharge Studio

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> General/Other

[Solved] Date Formats on update incorrect

Author

Message

bobbyrabbit

Posts: 5

Posted: 11/24/2011, 9:18 AM

I have just noticed that when I update a date eg. dd/mm/yyyy it will update the database entry as mm/dd/yyyy unless the day or month is higher than 12.

I have all locales set to dd/mm/yyyy with United Kingdom and short date in the connection settings in Codecharge 4.3.

Any ideas?

djgjohn

Posts: 52

Posted: 12/01/2011, 12:58 AM

Have you set the Format and DBFormat for the date field in CCS?

bobbyrabbit

Posts: 5

Posted: 12/01/2011, 1:15 AM

Quote djgjohn:
Have you set the Format and DBFormat for the date field in CCS?

Thanks for your reply. Yes I have!

andrewi

Posts: 162

Posted: 12/01/2011, 11:44 AM

The two crucial settings, I think, are the Project-->Settings Locales&Encodings Date Display Format (which you've already mentioned); and the Date Format on the Server tab of the Connection properties. This last setting must match what the database expects, and if your dates are going in wrong you could try reversing the day and month positions here.

(If you get the project-level settings correct you shouldn't have to alter any setting at the control level. I leave the individual control's DBFormat blank for all date fields. )

bobbyrabbit

Posts: 5

Posted: 12/01/2011, 1:10 PM

Thanks for your replies.

I unticked "Use Internationalization Features" in Locales & Encodings. That has seemed to have fixed it!

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

PHP Reports

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

Home | Search | Members | Register | Login