CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> Perl

 MS Access date using Perl & CGI

Print topic Send  topic

Author Message

Posts: 6
Posted: 07/20/2004, 12:12 PM

How do you format a MS Access date using CC, Perl, MS Access and CGI.

I have two Perl modules Date::Calc and Date::MSAccess installed, but I can not figure out how to configure CC to display only the date without the time field showing at the same time.

The date field now displays as: 2002-08-01 00:00:00

I want it to only display: 2002-08-01



View profile  Send private message

Posts: 5971
Posted: 07/20/2004, 9:20 PM

You should be able to specify the format in the "Format" property of the control. For example "yyyy-mm-dd".
Peter R.
YesSoftware Forums Moderator
For product support please visit
View profile  Send private message
Posted: 09/29/2004, 2:44 PM

Use DateFormat class in java.text package. It's not tough. Find the appropriate method in API.
Posted: 06/13/2005, 10:40 PM

i am trying to retreive the date field from access databse from jsp.
but i have recive date field 1980-02-12 00:00:00. how can i get
proper format.

Please reply me
Last Hero
Posted: 06/14/2005, 10:07 AM

1.Create grid where for this table
2.Change DataType for Date Field to "Text", not "Date".
3.Look what displayed in Date label.
4.Change DataType for Date Field to "Date", and set correct format. What farmat you can look at step 3.

Add new 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.