HELP TIME IS RUNNING OUT ON ME 1

[StanKorn]

Hi everyone,
I need to convert a text field of date data YYYYMMDD format and am struggling with the formula (This machine doesn't have Help on it :-( ...)Can someone pleeeese help me out of this bind.
Many thnx,
Stan

 

[Reebo99]

Try:

date(picture({datefield},"xxxx/xx/xx&quot)

And let me know how you get on.....

Reebo
Scotland (Sunny with a Smile)

 

[Reebo99]

Oh, and change {datefield} with your real text field....

Reebo
Scotland (Sunny with a Smile)

 

[StanKorn]

Thanks
Worked like a charm.

 

[synapsevampire]

First the date:

cdate(val(left("200011231",4)),val(mid("200011231",5,2)),val(mid("200011231",7,2)))

or you can use:

cdate(mid("200011231",5,2)+"/"+mid("200011231",7,2)+"/"+left("200011231",4))

As for the help, this is a common problem, and may simply require a registry change, I usually just do Step B in the following and it works:

http://support.crystaldecisions.com/library/kbase/articles/c2010291.asp

-k

 

[StanKorn]

Thanx synapsevampire.
I'll check the link out when I get this report out
Stan