Hi-
I've had some weird issues during my programming with Alpha... BUT this is the strangest. I hope you can help!
I inherited an application from another programmer who is no longer available to support the application. I'm the new programmer and support person.
I was notified by the customer, in June, that one of the reports that they use regularly ("New Hires Report"), "randomly" won't display the employee's Birth Date.
The rest of the record displays perfectly... and the rest of the report works great. The back-end database is SQL Server. AND... when I execute the table on the server's SQL Server, all of the Birth Dates display perfectly. AND... when I run the report in Working Preview or Live Preview on my development system, all dates display perfectly.
I've been trying to diagnose this for a couple of weeks... Why do most of the dates display fine, but "some" do not?
Well, it took some detective work, but I have discovered that all Birth Dates prior to 1970 don't display... Any Birth Dates after that date display properly (that's why it's infrequent, most of the people hired by this retail store chain happen to be younger than 45).
Like I said... It's very weird. All dates display on my system... and all dates are correct on the Server's SQL Server... BUT the report won't display any Birth Dates prior to 1970.
Here's some additional information:
I have no idea why 1970 is special... but I'm more frustrated now that I've figured out why some dates aren't displaying.
If you have any ideas, you will rise to "hero" status... I've spent way too much time on this puzzle.
I hope you can help.
Phil
I've had some weird issues during my programming with Alpha... BUT this is the strangest. I hope you can help!
I inherited an application from another programmer who is no longer available to support the application. I'm the new programmer and support person.
I was notified by the customer, in June, that one of the reports that they use regularly ("New Hires Report"), "randomly" won't display the employee's Birth Date.
The rest of the record displays perfectly... and the rest of the report works great. The back-end database is SQL Server. AND... when I execute the table on the server's SQL Server, all of the Birth Dates display perfectly. AND... when I run the report in Working Preview or Live Preview on my development system, all dates display perfectly.
I've been trying to diagnose this for a couple of weeks... Why do most of the dates display fine, but "some" do not?
Well, it took some detective work, but I have discovered that all Birth Dates prior to 1970 don't display... Any Birth Dates after that date display properly (that's why it's infrequent, most of the people hired by this retail store chain happen to be younger than 45).
Like I said... It's very weird. All dates display on my system... and all dates are correct on the Server's SQL Server... BUT the report won't display any Birth Dates prior to 1970.
Here's some additional information:
- There's nothing in the "table" that filters the date in any way;
- There's nothing in the report's field definition that filters the date (and, remember, the record displays perfectly... it's just that the date is blank)
- The report, in "preview" mode on my system displays all Birth Dates correctly
- I've tried converting the date to a string (with "Str")... the same dates are blank
- I've tried using various date formats (with "dtoc" and calculated fields)... no matter what I do, the same Birth Dates are blank.
I have no idea why 1970 is special... but I'm more frustrated now that I've figured out why some dates aren't displaying.
If you have any ideas, you will rise to "hero" status... I've spent way too much time on this puzzle.
I hope you can help.
Phil
Comment