/* use: You can place this in your stored procedures/Queries so you wont have datetime headaches.
Example:  select * from table where transaction_date >= dbo.fn_simpleDT(@FromDate,1) 
AND transaction_date <= dbo.fn_simpleDT(@ToDate,1) 

Format = 1 is 'yyyymmdd'
Format <> 1 is 'yyyyddmm' 

www.brainclone.com  */

create function fn_simpleDT(@indate datetime, @Format bit)
returns nchar(20)
as


Begin
	declare @Returndate nchar(20)

	if @Format = 1
	set @Returndate = (
	select convert(nvarchar(20), datepart(yy, @indate)) 
	+ convert(nvarchar(20), datepart(mm, @indate)) +
	convert(nvarchar(20),datepart(dd, @indate)) )

	if @Format <> 1
	set @Returndate = (
	select convert(nvarchar(20), datepart(yy, @indate)) 
	+ convert(nvarchar(20),datepart(dd, @indate)) +
	convert(nvarchar(20), datepart(mm, @indate)) 	)
	
	return(@Returndate)
end
go