473,406 Members | 2,371 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Showing date as May 10 2006 not 05/10/2006

How do I get dates stored in Access to show on
asp page as May 10 2006, or even better May 10th 2006?

Is there a special format I should store the date as?
Have tried various formats, long/short, but keep getting
it to show up as 05/10/2006.

Any asp code I can slap in there to fix this before it
drives me nuts?

I have no control over the web server.

Torbjorn
May 10 '06 #1
2 1169
Not the whole picture (e.g. the 1st, 2nd, 3rd, 4th suffix is extra), but a
start:
http://www.aspfaq.com/2313

"Torbjorn Pettersen" <to******@fantafiction.com> wrote in message
news:12*************@corp.supernews.com...
How do I get dates stored in Access to show on
asp page as May 10 2006, or even better May 10th 2006?

Is there a special format I should store the date as?
Have tried various formats, long/short, but keep getting
it to show up as 05/10/2006.

Any asp code I can slap in there to fix this before it
drives me nuts?

I have no control over the web server.

Torbjorn

May 10 '06 #2
should help
http://www.powerasp.com/content/new/...e-and-time.asp

"Torbjorn Pettersen" <to******@fantafiction.com> wrote in message
news:12*************@corp.supernews.com...
How do I get dates stored in Access to show on
asp page as May 10 2006, or even better May 10th 2006?

Is there a special format I should store the date as?
Have tried various formats, long/short, but keep getting
it to show up as 05/10/2006.

Any asp code I can slap in there to fix this before it
drives me nuts?

I have no control over the web server.

Torbjorn

May 13 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: hasanainf | last post by:
Hi all, What will be the best database design for an inventory control that uses expiry date for its products. Over a period of time, a particular product will have many expiry date and that...
2
by: karmaverma | last post by:
I need help with this apparently simple problem. I have a table with the following records: Effective_Date Commodity Price 10/1/2005 0 5/1/2006 2750 10/1/2006 ...
3
by: Henry Lee | last post by:
hi , all In ASP2.0 , the date object always showing like "3/27/2006 12:00:00 AM" How to remove "12:00:00 AM" and only make it shows "3/27/2006" ? Thanks very much Henry
67
by: PC Datasheet | last post by:
Transaction data is given with date ranges: Beginning End 4/1/06 4/4/06 4/7/06 4/11/06 4/14/06 4/17/06 4/18/06 4/21/06 426/06 ...
22
by: petermichaux | last post by:
Hi, I would like to display a message to Internet Explorer clients to encorage them to get Firefox. Yes they may like Internet Explorer but it is my site :) http://www.explorerdestroyer.com/...
1
by: Jonathan | last post by:
I have the following query which is retrieving a set of data it is almost what I want but I can not manage to get the result I desire. SELECT r1, r1_dev, r2, r2_dev, date, time FROM output...
4
by: sck10 | last post by:
Hello, I created an ashx file for my rss feed (rss.ashx). I notice on the site (http://rss.msnbc.msn.com/id/3032091/device/rss/rss.xml) that the date (Yesterday, October 30, 2006, 3:02:37 PM)...
9
by: ice | last post by:
Hello, I have a couple of tables. The client tables and the contacted tables. I am not sure how to start on this, what I need is a way to query all my clients then show any client that the...
1
by: DJo | last post by:
I am trying to insert a set of date variables to use in a stored proc that will automatically select the last 12 running months worth of data grouped monthly. This code stops at the end of the prior...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.