"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,who is the number 37317) to a date(dd-mm-yyyy) that needs to appear in a report (CR) through VB.
Is possible to convert the number 37317 in a crystal date format(yyyy-mm-dd)??
I've tryed inumerous options and ways with no luck. Is there anyone out there who can give me a hand!? ...
Is very urgent....
Any tips are welcome and apreciated!
thanks..

 

[Mar101665]

Check out this kbase to see if it can help you.

http://support.crystaldecisions.com/library/kbase/articles/c2001866.asp

 

[yjoke]

thank you.I tried the formula in the link that you suggest, but when I apply it in the formula editor, I get the message: " A statement is expected here ". I don´t know what that statement is.
Please help me again with any suggestion.

ThanK you..

 

[yjoke]

thank you.I tried the formula in the link that you suggest, but when I apply it in the formula editor, I get the message: " A statement is expected here ". I don´t know what that statement is.
Please help me again with any suggestion.

ThanK you..


hhhhheeeeeellllllpppp!!!

 

[yjoke]

I tried the formula in the link that you suggest, but when I apply it in the formula editor, I get the message: " A statement is expected here ". I don´t know what that statement is.
Please help me again with any suggestion.

ThanK you..

please i need help....