Wrox Programmer Forums
|
Classic ASP Components Discussions specific to components in ASP 3.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Components section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 19th, 2004, 03:49 PM
Registered User
 
Join Date: Feb 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Date Fomatting

Hello,

Ok this is rather simple I believe but I am just having a rough time. I need to format the following into a readable date and time.

Date:
20040218 'This is what I have now
02/18/2001 'This is what I want

Time:
093300 'This is what I have now
9:33 'This is what I want

Any suggestions would be of great help. Thanks in advance.

 
Old March 8th, 2004, 06:32 AM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 479
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via MSN to surendran Send a message via Yahoo to surendran
Default

k=20040218
k1=mid(k,1,4)
k2=mid(k,7,5)
k3=mid(k,5,2)
Response.Write k3&"/"& k2&"/"&k1



surendran





Similar Threads
Thread Thread Starter Forum Replies Last Post
copy date values between date controls Alcapone Javascript How-To 1 April 13th, 2006 03:13 AM
need help in Datagrid fomatting prasadd ASP.NET 2.0 Professional 1 October 31st, 2005 07:21 AM
Outlook Email Fomatting roguedog Access 1 February 1st, 2005 05:02 PM
DTS Import ( Date string to Date field) gfowajuh SQL Server 2000 1 September 30th, 2003 06:28 AM
Convert String Date to Date for a SQL Query tdaustin Classic ASP Basics 4 July 7th, 2003 06:01 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.