May 30, 2007 #1 MaryKay1 IS-IT--Management May 16, 2007 13 0 0 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 0 0 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 0 0 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 0 0 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 0 0 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 0 0 US I working now Thanks for your help synapsevampire. Mary Upvote 0 Downvote