Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

yjoke

Programmer
Joined
Feb 14, 2002
Messages
26
Location
PT
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!
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top