I am writing a store procedure , which generates reports for every fiscal quarter.
I am passing YEAR as input argument -- input_arg_year , and we have start and end ( day and months for fiscal quarters as constants)
now my question is how can i append start and end dates with the year( input_arg_year) to form a valid date. which can be used further in my store proc, for report generation.
Ex: Jan1st is quarter start date and input arg is 2008
date = 01012008 .......something like this
let me know, how can i append and convert the string into a valid date.
give an example , so that can understand easily , i am a naive developer ( basically asp.net developer)