I hope someone will be able to help me out here.
Im trying to use the following SQL statement in Teststand 3.0:
select first datepart(week, dateadd(day, -1, '2007-02-12'))
It should return which week that 2007-02-12 corresponds to. In this case week 7.
The first part where Im making the SQL statement works it seems. But then I want to retrive the data
which is done in the data operation step. But this step requires that I link the data to the right column in the database
as this is a function that I am using in the database (to calculate the week).
Either Teststand is a bit primitive when it comes to using SQL and can only access columns and no more.
Or I have simply overlooked something.
