How to convert 980715 string to 07/15/98 string 
Author Message
 How to convert 980715 string to 07/15/98 string

mid(980715,3,2)+"/"+mid(980715,5,2)+"/"+left(980715,2)

Jim

Quote:

> Hi, there

> I am doing Crystal Report using ver . 4.06   Could you tell me
> How to convert  980715  string to  07/15/98 string
> in crystal report

> 980715  string type date from database   I like to show it  07/15/98.
> But I could not find  something  like  mid$("980715",1,2) in crystal
> report.

> if you have any idea, please let me know by sending email to


> Thank you very much in advance !

> Lisheng



Tue, 02 Jan 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. converting a string to a long (string contains a Hex number)

2. Converting an unicode string to ascii code string

3. BinaryRead - howto convert binary string back to string array

4. Converting Hex string to Bi string in QB

5. How convert API lpsz String to BASIC string?

6. converting string pointer to string

7. Efficient converting from byte-string to word-string

8. convert a string in a HTML string ?

9. Convert String to hexadecmial string

10. Convert Base16 Hex String to Base58 String

11. How to convert extra long strings into their equivalent Hex Strings in VBA (Word 2K)

12. How to convert string to binary and then convert string back to binary for usage in UDT

 

 
Powered by phpBB® Forum Software