[Google]
Online Marketing
Add blog to our directory.

Calculate Begin and End Dates for Month/Year

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

Changing the Century for Calendar or Defaults for Effective dates

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