Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

extract year from Date prompt

Status
Not open for further replies.

Josh1777

Programmer
Apr 22, 2009
8
IN
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top