Problem converting date/time string to date string

[Jonesxx]

Hi,

I am using Crystal 8.5 and I am trying to convert the field cont.hist (which is a date/time string) into only a date string.

The formula I have used is:



IF DTSToDateTime ({CONTHIST.CREATEON}) then DTSToDate ({CONTHIST.CREATEON})Else 0


I keep on getting an error saying that a string is required. Any ideas?


Thanks v m

 

[Jonesxx]

Sorry I made a mistake, I'm trying to convert the date/time value so that the Conthist.Createon field is only a date type.

 

[lbass]

If it's already a datetime, then you can just use:

date({Conthist.Createon})

-LB

 

[starbase59]

Convert datetime to a varchar(8), e.g. @Date varchar (8)
I've done it in the stored procedure behind the Crystal report.

 

[synapsevampire]

The fastest metod would be a SQL Expression on the database using a CAST or CONVERT, providing your database has a DATE type (for instance SQL Server does not). You didn't bother to post your database type so I can't supply the syntax.

Otherwise Lbass's solution should work for you.

-k