Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Format - Remove Time

Status
Not open for further replies.

MaryKay1

IS-IT--Management
May 16, 2007
13
US
I have a Date field in Crystal Report called ReprotDate that shows: 5/15/2007 12:00:00AM - is it possbile to remove the time from it?

Thanks in advance
 
Use a formula of:

cdate({tale.datetime})

Depending on your requirement, you can just change the display properties by right clicking it and selecting format field.

-k
 
Is giving me an error: This field name is not known, this the formula that I put:
cdate({{BDF.ReportDate}})
 
Why do you have double braces around it?

Sometimes posting does this...

When you create the formula, select the database field from up above rather than typing it in, it will insert it for you, which eliminates errors.

-k
 
I removed the bractes, is giving me new error: The formula result must be a boolean?
 
I working now Thanks for your help synapsevampire.

Mary
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top