convert to a date

[Paul1981]

Hi,

I'm using Crystal Reports XI and have a number field which is:

20071213
YYYYMMDD

how do I make this into a date field crystal will reconise?

Thanks
Paul

 

[dgillz]

Numbertodate({YourField})

You will need to download the numbertodate() function first:

http://technicalsupport.businessobj...sliceId=&dialogID=5070535&stateId=1 0 5068442

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[IanWaterman]

Create formula

date(tonumber(left(totext(20071213,0,""), 4)), tonumber(mid(totext(20071213,0,""), 5,2)), tonumber(right(totext(20071213,0,""), 2)))


replace 20071213 with your number field.

Ian

 

[dtmb]

Thanks for the info on this one.