NumberToDate formula from 6.0 to 7.0

[Bigpollack]

I have just upgraded from 6.0 to 7.0
Several of my reports in 6.0 have the NumberToDate function in them, but this gives me an error in 7.0
I can't seem to find the number to date formula in 7.0 ??
I can convert an actual number, but when I put a field name it gives me an error.
MACOLA stores it's date fields as 20011025
BTW, being able to display the file name and path was worth the upgrade alone !!!!

 

[mbarron]

If your field is a number try:

Date (tonumber(totext({datefield},0,"&quot[1 to 4]),
tonumber(totext{datefield},0,"&quot[5 to 6]),
tonumber(totext({datefield},0,"&quot[7 to 8]) )

 

[kenhamady]

I don't think this is a CR function. It was probably a custom function that you downloaded or added to CR6. If so you need the same DLL added for CR7. Are they on the same PC?

However, Macola numeric dates can be converted using the formula listed above by mbarron. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[Bigpollack]

Bingo !! Thanks for the help, it was a custom DLL.
I did a dogpile search for NumberToDate and came up with the following link.

http://home.planet.nl/~gdeboom/Report1.html

It had the formula in there, along with a few others that look to be helpfull.
This is the first time I've used this Tek-Tips, but you can be sure it wont be my last.