convert numeric to date

[witt]

Is there a way to convert a numeric field (containing a date in the format YYMMDD, eg. '030401' for April 1, 2003) to a date field?

thanks
Witt

 

[dgillz]

NumberToDate(20000000+{YourField})

You will need to download NumbertoDate() from the crystal decisions website. This is a UFL which is not normally shipped with your Crystal CD.

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

http://www.trianglepartners.com

 

[Reebo99]

You can use :

Date(
Right(totext(030401,"000000&quot,2)&"/"&
Mid(totext(030401,"000000&quot,3,2)&"/"&
Left(totext(030401,"000000&quot,2)
)

Reebo
Scotland (Sunny with a Smile)

 

[mrnez]

Hello

I am looking for a way to convert the following into a readable format (it is an Microsoft UTC date from an event log) I am reading data in from an SQL database but want the report to display it in a nice format

Thanks in Advance

Rich

20030529085254.000000+060

 

[Reebo99]

You should start a new thread for this........

Anyway, use :

//For string datetime
DTSToDateTime(Picture({field},"xxxx/xx/xx xx:xx:xx&quot)

//For numeric datetime
DTSToDateTime(Picture(totext({field},0,"&quot,"xxxx/xx/xx xx:xx:xx&quot)

replace italics with your field.....


Reebo
Scotland (Sunny with a Smile)