asked on
Get Current Year Syntax in Switch Statement SSRS 2005
In the following Switch statment, I have hard-coded the date 12/31/2010; however what I really need to do is have 0000 = 12/31/CurrentYear. Can someone please help me with the syntax.
Thanks,
=Switch
( Fields!Combo_3.Value = 0001,DateAdd("D",730,Field
Fields!Combo_3.Value = 9999,"N/A",
Fields!Combo_3.Value = 0000,CStr("12/31/2010"),
Fields!Combo_3.Value = 0002,"Past Due",
Fields!Combo_3.Value,Forma
Right( Fields!Combo_3.Value , 2 ) & "/" &
Left( Fields!Combo_3.Value , 4 ) )
)
Thanks,
=Switch
( Fields!Combo_3.Value = 0001,DateAdd("D",730,Field
Fields!Combo_3.Value = 9999,"N/A",
Fields!Combo_3.Value = 0000,CStr("12/31/2010"),
Fields!Combo_3.Value = 0002,"Past Due",
Fields!Combo_3.Value,Forma
Right( Fields!Combo_3.Value , 2 ) & "/" &
Left( Fields!Combo_3.Value , 4 ) )
)
Microsoft SQL ServerSSRSSQL
Last Comment
VTFatcat1973
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
yes true lol. I missed SSRS in the title and read the zone, doh!
ASKER
You both were a big help. I split up the points see I kinda mislead with T-SQL as it was SSRS code. Shaun's Syntax was right on ;-) Thanks
year(getdate())
or
Select datepart(year,getdate())