I got my query to work in the management studio, so I think it is just a matter of how to call if from the Action Item. Can anyone see what I am doing wrong there?
Thanks for the help.
–HandledException
[code]DECLARE @year Int,
@month Int,
@day Int,
@hour Int,
@minute Int,
@second Int
DECLARE @newDate DateTime
SET @year = 2009
SET @month = 8
SET @day = 7
SET @hour = 10
SET @minute = 30
SET @second = 10
SET @newDate = dbo.DateTime(@year, @month, @day, @hour, @minute, @second);
PRINT @newDate[/code]