extract year from Date prompt

[Josh1777]

In the Report Studio i need to select start Year and end Year.
for this i used date promptand kept range property 'yes'
now if i want only year to be selected from the prompt wat to do.

if there is an alternate way pls suggest

 

[AngelaCognos]

extract(year,[YourDateField])

 

[masterj1109]

You can also use a SQL statement in your query to break apart your date field and pull out the year, I'm not sure exactly how you have your dates formated, but "substring()" should work, with the correct converts if needed