Home arrow static arrow Java Programming [Archive] - Formatting Dates - Please Help!!!
Warning: Creating default object from empty value in /www/htdocs/w008deb8/wiki/components/com_staticxt/staticxt.php on line 51
Java Programming [Archive] - Formatting Dates - Please Help!!!
This topic has 11 replies on 1 page.

Posts:2
Registered: 8/3/04
Formatting Dates - Please Help!!!  
Aug 4, 2004 1:00 AM



 
Hello to all you Java Gurus,

Just to give u a little background wiki/./into my problem, i am a co owner of a company and have a large customer database (dunno why but the database is in excel at the minute), however the lady who inputs new customers has entered the wrong date format for the last few months so as you can imagine there are too many dates to go through individually and change to the correct format. Your probably thinking why don't i just highlight the dates - format cells and put it into the correct date format but don't worry i have tried that and it doesn't work, i was told about the powers of java being able to help me here and that this forum was very helpful so i have read some books and attempted to write some code in order to change the dates from this format 03 08 04 to 03-Aug-04 (dd-MMM-YY) but it doesnt really work - AT ALL, hehe!!

IS it possible if someone has code to do this or knows how to do this if they could help me, i will give the person who can solve what is probably an easy problem for you guys all my 25 dukes as i will probably never need to use Java or the forum again anyway

Thanks a lot, hope you can help asap

Paul
 

Posts:221
Registered: 6/3/98
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 1:22 AM (reply 1 of 11)



 
Hi.

Try this:

1. Select all the cells that need to have the date format changed
2. Go to the Edit/Replace menu
3. In the 'Find What' text area, type a single space
4. In the 'Replace With' text area type a slash ('/')
5. Press the 'Replace All' button
6. Format the cells in whatever date format you like

Regards,

Lance
 

Posts:2
Registered: 8/3/04
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 1:27 AM (reply 2 of 11)



 
Well as you can see computer literacy isn't one of my strongest points and java wasn't needed, cheers for your help Lance, as promised and that i will probably never come on here again, here is all of your dukes, have a nice day

Paul
 

Posts:221
Registered: 6/3/98
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 3:52 AM (reply 3 of 11)



 
No problem. Glad to be of help.

Regards,

Lance
 

Posts:19,725
Registered: 9/26/01
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 5:32 AM (reply 4 of 11)



 
<suspicious>
Hmmm, "lance.walton" doesn't post anything for a long time, and just 'happens' to be online at the same time as 'staindfan0000' and 'answers' a simple question to give 'himself' 25 more dukes?
Hmmm???
</suspicious>
 

Posts:24,036
Registered: 2/3/03
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 6:16 AM (reply 5 of 11)



 
<suspicious>
Hmmm, "lance.walton" doesn't post anything for a long
time, and just 'happens' to be online at the same time
as 'staindfan0000' and 'answers' a simple question to
give 'himself' 25 more dukes?
Hmmm???
</suspicious>

Tin foil makes a wonderful head covering; the government mind-control beams bounce right off. ;o)

J/K. Besides, don't you know how valuable those Ducks are? It's worth it to cook up another MIP just to get another cool 25... :o)
 

Posts:221
Registered: 6/3/98
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 1:17 PM (reply 6 of 11)



 
<suspicious>
Hmmm, "lance.walton" doesn't post anything for a long
time, and just 'happens' to be online at the same time
as 'staindfan0000' and 'answers' a simple question to
give 'himself' 25 more dukes?
Hmmm???
</suspicious>

I find your in depth analysis of this coincidence fascinating. What is utterly opaque to me is exactly what you are suspicious of. Clearly, from the number of question marks you've used, you want something answered. Maybe if you clarified what it is, I can provide some answers for you too.

Lance Walton
 

Posts:6,750
Registered: 1/25/04
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 1:21 PM (reply 7 of 11)



 
I find your in depth analysis of this coincidence
fascinating. What is utterly opaque to me is exactly
what you are suspicious of.

Seriously? You can't figure it out?
 

Posts:668
Registered: 9/2/03
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 2:06 PM (reply 8 of 11)



 
What is utterly opaque to me is exactly
what you are suspicious of.

Come on now, like we haven't seen this posting-behaviour before...? To be honest, the first glance
here gave me the impression you wanted to get some easy dukes.
 

Posts:221
Registered: 6/3/98
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 3:14 PM (reply 9 of 11)



 
I find your in depth analysis of this coincidence
fascinating. What is utterly opaque to me is exactly
what you are suspicious of.

Seriously? You can't figure it out?

I have an inkling... I just wondered if the fellow has the guts to actually spell it out for me, or if he's just a puke and run type.

If he truly believes it, then by all means he should report it as abuse.

Regards,

Lance
 

Posts:221
Registered: 6/3/98
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 3:58 PM (reply 10 of 11)



 
What is utterly opaque to me is exactly
what you are suspicious of.

Come on now, like we haven't seen this
posting-behaviour before...? To be honest, the first
glance
here gave me the impression you wanted to get some
easy dukes.

OK. But you did the sensible thing and ignored the thread, whereas warneja wanted to make himself known as the super-sleuth or upholder of morality he clearly believes himself to be, and responded. In so doing he failed to consider the following possibilities:

1. It may just have been a real question and answer
2. I might have bought a house that needs renovation a couple of months ago, hence my absence from the forums
3. I might get bored with the idiots on the forum after a while a not visit for a couple of months until some terrible fascination draws me back
4. I might have a real job that pays me real money and takes up a lot of time
5. I might not actually give a hoot about Dukes
6. I might have a hobby, such as music composition, that takes up a great deal of my spare time and has engaged me more than the forums have recently
7. If I was going to engage in the dreadful crime I stand accused of, I might actually have asked a question about Java rather than Excel, given that it would take less imagination and would not be out of place in a Java forum

In short, I might actually have a life and not be a pathetic, small minded donkey whose greatest ambition is to earn Dukes and gain the respect of my fellow Equus Asini.

Regards,

Lance
 

Posts:6,750
Registered: 1/25/04
Re: Formatting Dates - Please Help!!!  
Aug 4, 2004 4:04 PM (reply 11 of 11)



 
In short, I might actually have a life and not be a
pathetic, small minded donkey whose greatest ambition
is to earn Dukes and gain the respect of my fellow
Equus Asini.

It's possible. Then again, you might not - none of us can be sure.
 
This topic has 11 replies on 1 page.