Like this?

WHERE site_code = @p_site_code

AND datepart(month,observ_date) = @p_startmonth

AND DATEPART(YEAR,observ_date)= @p_startyear

AND DATEPART(MONTH,observ_date) <= @p_endmonth

AND DATEPART(YEAR,observ_date)= @p_endyear

https://social.technet.microsoft.com/Forums/azure/en-US/6c6e4fba-be40-4c53-ab8e-348ccd39c687/rename-file-using-file-system-task-editor?forum=sqlintegrationservices

I just have the .rdf file, no oracle on machine, no conversion tools, which is what I am looking for. An app that someone may have used to open them...

I'm just curious are all of you always so rude? Of course I googled it, nah really I just jumped on and wanted someone else to do all the research.

Yes they are, no calculations will be done on them.

• This reply was modified 4 years, 7 months ago by  cbrammer1219.

Here is some sample data, I have removed any data that had identifying information, phone numbers and faxs and names and addresses

No it isn't and youre talking about the decimal fields correct?

Original Table from AS400
SELECT
  NOUSGE,  /* NOUSGE  CHARACTER(1)    DO NOT USE FLAG */
  MVEND,   /* MVEND  ...

I got this to work, however if the month is 1-9 it sets the date to '01/01/1900' because of the month not having 2 digits.

CASE WHEN ISDATE(left([Due Date],2) +'/'+ SUBSTRING(right([Due...

Are you talking about this code? This doesn't work I get the same error.

DECLARE @DateStr NVARCHAR(50) = N'12172019';

SELECT @DateStr,

CAST(CONCAT(RIGHT(@DateStr, 4), LEFT(@DateStr, 2), SUBSTRING(@DateStr, 3, 2)) AS DATE);

I have searched, and none of the solutions have worked. otherwise I wouldn't have posed my issue.

it is defined as [Due Date] (nvarchar(10),null)

Thanks for getting back to me, the Due Date is formatted like this 12172019 and does have zeros in the field also, it is being imported from an excel spreadsheet....

I followed the advice Sue had given, I read the document she provided the link to and setup the link server, I can query the as400 tables as I would...

I'm not understanding this, Is the SQL table only at length of 3? I have increased all of the sizes on the SQL side so not sure why I am...