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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert numeric to date?

Status
Not open for further replies.

Fursten

Programmer
Dec 27, 2000
403
PT
Hi

In Visual Basic I get a data from a numeric field by doing: Cdate(field, format)

In Crystal8.0 I had tried to do the same: Cdate(field), however that doesn´t work :( I always get the same date...

It seems that these functions are diferent from Visual Basic to Crystal...

Any ideias?

Thank you

Sergio Oliveira
 
If you are using a formula to convert a date, there are various techniques, basically made up of joining the elements together in a formula field using the following formula

date(year,month,day).


I hope this is what you wanted


Jason
 
I have a number to date UFL I can email you. The function converts an eight digit integer in the YYYYMMDD format to a date.

If interested email me and I will send one your way.

dgilsdorf@altavista.com Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
 
There is also a formula you can copy in faq149-243 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top