"URGENT" - How to convert a number in SQL to a date in CR through VB?

[yjoke]

Hi there. I've been having some (lots of) problems in a project that I'm working on. I'm using an SQL 2000 database, Visual Basic 6.0 SP5, and Crystal Reports 8.5 Pro.
One of the problems that I'm facing is in converting a date from an Integer (in SQL 2k) to a date(dd-mm-yyyy) that needs to appear in a report (CR) through VB.
I've tryed inumerous options and ways with no luck. Is there anyone out there who can give me a hand!? ...

Any tips are welcome and apreciated!

 

[dgillz]

If your number is an 8 digit integer in the YYYYMMDD format, use the numbertodate() function. Numbertodate is a UFL that is on the CD website.

I do not know how to express this is VB, unfortunately. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com