CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> Perl

 MS Access date using Perl & CGI

Print topic Send  topic

Author Message
jg1130

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

Thanks,

Juan

View profile  Send private message
peterr


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 http://support.yessoftware.com
View profile  Send private message
vishwas
Posted: 09/29/2004, 2:44 PM

Use DateFormat class in java.text package. It's not tough. Find the appropriate method in API.
sathish
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 http://support.yessoftware.com.

Web Database

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

Home   |    Search   |    Members   |    Register   |    Login


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