Bad Date Format String 1

[retygh45]

Using CR11, I have a string field that stores a date in the format 20070907

I'm simply trying to turn this string into a date so I can report off it, but when I do: Cdate({table.field})

I get an error of "Bad Date Format String". Any ideas as to what would be causing this? Thanks!

 

[retygh45]

nervmind, I found a post with what I was looking for:

//@convert to date
local stringvar input := "20060628"; //replace with your field
date(val(input[1 to 4]),val(input[5 to 6]),val(input[7 to 8]))

Thanks!

 

[dgillz]

Your formula has limitations as it is a print time formula (uses variables) and cannot be used for grouping. So just write a simpler formula:

Date(val({YourField}[1 to 4]),val({YourField}[5 to 6]),val({YourField}[7 to 8]))

You might also look at the NumberToDate() function which is specifically designed to take an 8 digit number in a YYYYMMDD format and convert it to a real date. This is a UFL download found here:

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

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[lbass]

Actually, you could group on the formula, as it does not use "whileprintingrecords" and the variables are not shared variables. Variables are not automatically unavailable for grouping.

-LB