|
|||||
|
 Calculate the Begin and End dates from a given Period/Year combination or to calculate the month’s begin and end dates from a given date. Like if you are given Period=3, Year=9, the Begin and End dates will be 03/01/2009 and 03/30/2009 respectively. Similarly if you were given a date say – 2/17/2009, the return Begin & End dates will be 02/01/2009 and 02/28/2009. . . . → Read More: Calculate Begin and End Dates for Month/Year A problem with SQL over JDE Data is the way Dates are stored in JD Edwards. JDE stores dates in Julian Format. The following SQL snippet can convert the Julian date into Gregorian Date format or Normal date. . . . → Read More: Convert Julian Date to Gregorian Date (SQL) From E812 and subsequent versions the operating mode or application control, the majority of Applications or Interactive process can only run in the WEB.In The table JDEOL812 / F9860, field SIANSIF defines . . . → Read More: Set EnterpriseOne Applications to RUN on FAT CLIENT The Century for Calendar or Defaults for Effective dates comes in as 2010, and any year more than that is automatically defaulted to 19XX, to fix it change the value of couple of Data dictionary items – CENTCHG & DCYR . . . → Read More: Changing the Century for Calendar or Defaults for Effective dates |
||||
|
Copyright © 2012 Deepesh M Divakaran - All Rights Reserved |
|||||
Recent Comments