Year(currentdate)

[Former Member]

Hi!

Can someone tell me why ? I create a Crystal syntax with this= Year(currentdate) and it return it like a number field 2 011,00 instead of a date format,

Thanks

Diane

[Former Member · Accepted solution]

Because the formula returns a number. You will need to format it to get rid of the comma and decimals by either formating the display of the formula or format it in the formula itself, making it a text field:

totext(year(currentdate)0,"")

Debi

Edited by: Debi Herbert on Mar 31, 2011 9:56 AM

[Former Member · Accepted solution]

I tried that and was unsuccessful

(Error message claims I forgot the ")" and highlights the "0")

This works when I added a comma between the date field and the "0"

totext(year({Safety Notices.Safety~Date}),0,"")

Edited by: Anthony Colatorti on Mar 31, 2011 11:02 PM

[Former Member]

Hi ! just to let you know,it work fine with this, thank for this post, I have found another way too,if you go through the Crystal Report options \field tab\ number\ and number tab, then customize, what I did is specified no decimal and unmarked thousand separator, it work fine too, thank you for your precious time