Hi:
I'm working with a system whose backend is written in AcuCobol, which is as alien to me as Urdu. The report is thirteen years old and is really ugly, but I'm trying to solve one of the more pressing and annoying problems with it first.
I have a field called Maturity Date. The field has a datatype of "date", and when I browse the data I see a number of dates formatted as MMDDYYYY, all of which appear to be correct. However, several of those dates display in my report with the wrong century (i.e. 19 as opposed to 20).
For example, when I browse the data for this field I see a number of dates 12/31/2049, but in the report those same dates display as 12/31/1949.
I have tried converting the field to a DATETIME and then done a DATEADD to the year, but THEN I get 4/10/1950 (which means it's adding to the days, not years). As an experiment I tried adding 100 to both the days and months, and neither yields the correct century.
I'm out of ideas. Anyone?
Thanks,
Chzhdgrrl