Perl problem that involves MSaccess

Posted on 2006-05-04
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.

Question by:deNZity
    LVL 9

    Accepted Solution

    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


    Author Comment

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


    Author Comment

    apologies got caught up.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Title # Comments Views Activity
    perl script 4 84
    Perl - Mawk 2 56
    Perl, group, sort, count question 6 100
    Can Oracle Client work with an Oracle 12c Database? 5 124
    On Microsoft Windows, if  when you click or type the name of a .pl file, you get an error "is not recognized as an internal or external command, operable program or batch file", then this means you do not have the .pl file extension associated with …
    Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
    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…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now