convert date to string!!

[katdbc]

Can you please help me correct this statement!!

Cast (([Report View].[Eye Charts].[YEAR] -1) ,varchar)

with this i have to conacatenate a text value

[Lynn]

Assuming the [YEAR] data item contains something like 2011 to represent a year, and is a numeric field (therefore worthy of subtraction), I'd suggest the following:

Code Select Expand


Cast ( ([Report View].[Eye Charts].[YEAR] -1) , VARCHAR(4) )


To concatenate:

Code Select Expand


Cast ( ([Report View].[Eye Charts].[YEAR] -1) , VARCHAR(4) ) + ' was a very good year'