Results 1 to 3 of 3

Thread: Need to figure out User Date Format from Login ID

  1. #1
    New Member
    Join Date
    Feb 2004

    Need to figure out User Date Format from Login ID

    I have searched the forums and haven't found a solution to this.

    I have a table that has dates stored as strings. They would have been created based on the users date profile. So while I can use B0500720 to get the system format mask then use B0001390 to get the users format mask in a process run by a user, I haven't been able to find a function or API that would let me pass in a USER ID and it tell me what that users date format is.

    I am trying to write a conversion that will take the date in the users format and change it to a JDEDATE. The table has various formats. MM/DD/YY, MM/DD/YYY, YYYY/MM/DD, and YY/MM/DD and also some variations on seperator as well.

    Any Ideas?

    This is in 9.1 AS/400 but I don't think the solution should be that hard. Seems like someone would have had this kind of requirement before.

  2. #2
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Cork, Ireland
    F00921.ULFRMT mate

    It uses UDC 00 DF and is entered in User Profile Revisions (JD Edwards Solution Explorer - User Options - User Profile Revisions)

    B9500928 (GetUserPreferenceInfoByUserID) , pass in the USER ID and it comes back with szDateFromat and a few other things too, time zone etc

    I don't think you can trust B0001390 as for me it brings back AOR, and I'm not I'm DMY
    Last edited by johndanter; 05-11-2018 at 01:21 AM.
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR Unix

  3. #3
    New Member
    Join Date
    Jan 2015

    There is BSFN available to get the USER Date Format - B9500928.

    You will get additional information for that USER ID.


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.