string:"yyyymmdd" to date format: #dd/mm/yyyy#

[luzippu]

How can I transform a string "yyyymmdd" (ie: 20020131) to a date format #dd/mm/yyyy# (ie: 31/01/2002)?

I cannot use @StrReverse() or @DateValue()...

Thanks in advance for your help

luzippu

 

[luzippu]

...continuing reading previous threads I found:

WhilePrintingRecords;
NumberVar input := {table.StartDate}; // or whatever your field name is
// This line checks for a minimum value, any value will work.
If input < 19590101 then Date (1959, 01, 01) else

Date ( Val (ToText (input, 0 , &quot;&quot [1 to 4]),
Val (ToText (input, 0 , &quot;&quot [5 to 6]),
Val (ToText (input, 0 , &quot;&quot [7 to 8]) )

thanks to

http://www.kenhamady.com

it now works correctly

 

[kenhamady]

Your welcome

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com