Results 1 to 4 of 4

Thread: Convert Date

  1. #1

    Convert Date

    JDE E1
    Application 9.2
    Tools Release
    Windows 8.1 Pro 64 bit

    I'm trying to import a csv via UBE. I'm parsing a date as string, e.g. 5/29/2019. I need to get it into the F42140 as STBMDT (format is 2019-05-29 00:00:00.000). I've been through a lot of threads in this forum looking for the right combination and haven't found it yet. That doesn't mean it's not there.

    I've tried a lot of date conversions and haven't found anything that will convert into STBMDT. I've added several variables to my code with different formats and the only ones that show when I look at the options for inserting or updating are UPMJ. I'm not sure how to get a string to a UPMJ so it can be inserted/updated into a STBMDT. At this point, it wouldn't surprise me to know that I've come across the solution in my attempts to work this out but I wasn't that far in my research yet. Things are starting to go around in circles!

  2. #2
    Per MOS, to convert the date/time to UTC, use Business Function B9800009 - Get UTC Time. You might also check out this doc.
    Attached Files Attached Files

  3. #3
    Thank you! I ended up using B90CA251 as that specifically updates/inserts to F42140 and puts the date into the format the file needs.

  4. #4
    Can you help me, i want to read other business function..
    what the url to download files of documentations business function ?

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.