Convert AS/400 date format

Tags:
AS/400
Can the AS/400 date be re-formatted?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hopefully i think you can re-format.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Of course it can. In order to say more, you'd need to explain what "date" you're asking about first. Then, formatting usually only makes sense in a presentation layer; so you'd need to describe the presentation technology. Finally, since "AS-400" has been replaced by later systems for many years, you should say what system version you have. Different methods might be available.
    36,880 pointsBadges:
    report
  • ToddN2000
    Changing the date on an existing system with a lot of history may cause you headaches. If you have date fields in your files and then change formats, only the new data will get store in the new format. That means selecting by date ranges and sorts will not give the correct results. Like Raven said, we need more info on why the change is needed and what type of system you are working on and the release of the OS.
    136,240 pointsBadges:
    report
  • philpl1jb

    Please be more specific.

    Is it an issue in reports or screens?

    How is the date stored on the system? As a true date field or as a numeric or char field. Please provide examples of data and how you want it stored? sent? etc.

    54,090 pointsBadges:
    report
  • BillJohnson76240
    Thanks for the interest. I am trying to write an AS-400 Query that will grab the results from the previous day's transactions in MAPICS XA.  I can enter the prior date manually but want to automate the query so it will run automatically each day. I have been able thru concantenation to get the date to the correct format but need to convert it to a decimal now.
    25 pointsBadges:
    report
  • TheRealRaven
    That helps some. Now we know that you're not working with DATE values but rather NUMERIC or CHARACTER values that represent "dates". What "query" product are you using? What form do the date values need to take?
    36,880 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: