May 30, 2007 #1 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
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
May 30, 2007 #2 synapsevampire Programmer Mar 23, 2002 20,180 US 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 Upvote 0 Downvote
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
May 30, 2007 Thread starter #3 MaryKay1 IS-IT--Management May 16, 2007 13 US Is giving me an error: This field name is not known, this the formula that I put: cdate({{BDF.ReportDate}}) Upvote 0 Downvote
Is giving me an error: This field name is not known, this the formula that I put: cdate({{BDF.ReportDate}})
May 30, 2007 #4 synapsevampire Programmer Mar 23, 2002 20,180 US 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 Upvote 0 Downvote
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
May 30, 2007 Thread starter #5 MaryKay1 IS-IT--Management May 16, 2007 13 US I removed the bractes, is giving me new error: The formula result must be a boolean? Upvote 0 Downvote
May 30, 2007 Thread starter #6 MaryKay1 IS-IT--Management May 16, 2007 13 US I working now Thanks for your help synapsevampire. Mary Upvote 0 Downvote