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