?
Solved

Perl problem that involves MSaccess

Posted on 2006-05-04
4
Medium Priority
?
205 Views
Last Modified: 2010-03-05
I have a question open in the MSaccess channel that I think is most probably a Perl problem.
A solution has been suggested but not how to implement it in the perl script.

http://www.experts-exchange.com/Databases/MS_Access/Q_21839084.html

D
0
Comment
Question by:deNZity
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
Suhas . earned 2000 total points
ID: 16611999
Hi deNZity,

$date = "29/03/2006";
($a,$b,$c) = split('/',$date);
$date1 = join('/',$b,$a,$c);

$date2 = join('/',$a,$b,$c);

print "$date1\n"; #prints 03/29/2006
print "$date2\n"; #prints 29/03/2006

#which ever date format you want you can pick

Cheers!
Suhas
0
 

Author Comment

by:deNZity
ID: 16621183
Hi suhasbharadwaj ,  
that looks like a solution. I will try it when I return to work next week.
Thanks for the reply.

D
0
 

Author Comment

by:deNZity
ID: 16796657
apologies got caught up.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Six Sigma Control Plans
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question