date format

  1. DMHERSH

    convert a number string to a date

    Hi I a beginner in using BI Publisher, I have a number string in my XML which looks like 20161130 I need to create a date format 30/11/2016 from it, in the past I have received the XML in date format so was able to get my date using the template builder. The code I have in the field currently...
  2. four digit year in RDA

    I am creating UBE where one of the date field has a value of 1/1/40. The UBE also exports to csv. When I export to csv, I noticed that the 1/1/40 changes to 1/1/1940. I did some research on this on Oracle Support. It is due to Microsoft 2029 rule. Oracle is recommendating the user profile be...
  3. Convert Julian Date to YYYYMMDD

    Hi List, I need help converting a Julian Date into a String of YYYYMMDD for a positive pay text file. I know there isn't a business function that does this and I have tried different ways of doing it but have hit a dead end. If anyone could help I'd appreciate it. I am running OneWorld on...
  4. peterbruce

    Date Format

    JDEList Administrators, Can the format for the date be change? The site (default) format is mm-dd-yyyy where the format that is used in my part of the world is dd-mm-yyyy. It can be very confusing, especially during the first 12 days of each month. I have not been able to find if there is any...
Top