convert numeric date to date 2

[JRine0101]

I have a field in my database that is defined as a numeric field but it is a date in format yyyymmdd. I would like to display it as "mm/dd/yyyy".

First choice is to convert it to a date so I can do whatever formatting I want, but it would make me happy just to have be able to display it as I previously described.

 

[vidru]

Converting to a Date would be the easiest way to deal with this. Here's one way to do it:

NumberVar dt := {Table.DateAsNumberField};
NumberVar yr := Int(dt/10000);
NumberVar mo := Int((dt Mod 10000)/100);
NumberVar dy := dt Mod 100;
Date(yr,mo,dy);

-dave

 

[dgillz]

Numbertodate({YYYYMMDD field}) works very well. NumberToDate() is a UFL which you may ned to download depending on your version of Crystal.

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

http://www.gainfocus.biz

 

[JRine0101]

That sounds good, but apparently I do need to download it. Where do I get it?

 

[jdemmi]

Wouldn't this work???

Date (val({TABLE.DATEFIELD}[1 TO 4]),val({TABLE.DATEFIELD}[5 to 6]),val({TABLE.DATEFIELD[7 to 8]))

(Then just apply CR's date formatting. Right Click, Format Field, Date tab)

-- Jason
"It's Just Ones and Zeros

 

[fredp1]

The UFL for Numbertodate can be downloaed from the BO support site.

Cheers
Fred