Convert Numeric Field to Date

[socalvelo]

CR XI

I have a date field that has numeric formatting (something a dba did in another dept).

The dates look like this: 20100922

Can someone give me a formula to properly turn this into a date field in CR until I get the dba to change it. Thank you.

 

[swiss2007]

I would use
date(val(mid({yourfield},1,4)),
val(mid({yourfield},5,2)),
val(mid({yourfield},7,2)))

 

[dgillz]

Numbertodate({Yourfield})

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html