• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Convert Date

JDE E1
Application 9.2
Tools Release 9.2.0.2
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!
 
Thank you! I ended up using B90CA251 as that specifically updates/inserts to F42140 and puts the date into the format the file needs.
 
Can you help me, i want to read other business function..
what the url to download files of documentations business function ?
Thanks
 
Top