Changing Text to Date 1

[SharonBrown]

I need to change two data fields that were created as "varchar" by our programmer. The two fields display the hours worked per day and the number of days per week. He needed to display the answer in our application. I need to be able to use the information to place in a report.

How can you change this to a number so I can sum the two together?

Thanks,
Sharon

 

[kenhamady]

Your heading was "Text to Date" but your question is to a number?

There is a formula in FAQ 1.B that allows you to convert a text date to a true date. It works with a text value like:

1/15/1997

----
Otherwise, the VAL() function converts a character numeric to a true numeric. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[Thanks]

I did mean to number, not date!

Thanks for the answer! I will go ready up on Val()

Sharon