• 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


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!


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 ?