September 10, 2009 at 12:18 pm
K one of my variables is using an expression as its value, based on the System::Starttime variable. It was working fine yesterday, but today i keep getting an error :
A truncation occurred during evaluation of the expression.
Here is the expression:
(DT_STR,1,1252) Day( @[System::StartTime] ) + "-" + (DT_STR, 1, 1252) Month( @[System::StartTime] ) + "-" + (DT_STR, 4, 1252) Year( @[System::StartTime] ) + "-" + substring((DT_WSTR,30)GETDATE(), 12,2)+ "-" +substring((DT_WSTR,30)GETDATE(), 15,2) + "-" + substring((DT_WSTR,30)GETDATE(), 18,2)
What changed from yesterday to today?
September 10, 2009 at 2:11 pm
Could it be because yesterday's day part of the date was one digit and today its two digit? 9th vs 10th?
Just a thought.
-Sups
September 10, 2009 at 2:18 pm
DOH!!! :pinch:
Lol thanx!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply