Null Date export to Excel - Progress Database

[megbytes]

in July 2009, Turkbear responded to a issue concerning null date export. I tried this solution on a Progress database to Crystal report and crystal returned
"12/31/-4714" as the date.

Mr. Turkbear, if you are listening, any suggestions for Progress Databases.

Thank you - your advice is always appreciated.


Turkbear (TechnicalUser) 29 Jul 09 15:14
In your report,create a formula to use in place of the actual date field:
@DateForm

CODE
If IsNull({DateField}) Then
""
Else
ToText({DateField},'MM/dd/yyyy') //Case sensitive

 

[Turkbear]

Hi,
Perhaps Progress stores NULL or unsupplied dates as that Date ( some databases do that, I am not familiar with Progress' default Date format) so try:

(
If IsNull({DateField}) OR ToText({DateField},'MM/dd/yyyy') = "12/31/-4714"
)
Then
""
Else
ToText({DateField},'MM/dd/yyyy')

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[megbytes]

T.Bear

yo da man

Take the rest of the day off

Meg

 

[Turkbear]

Hi,
Glad I could help..( I take every day off, its is the joy of retirement )





To Paraphrase:"The Help you get is proportional to the Help you give.."