SUBSTRING(DocDate, 7, 4)? 1

[sk8ology]

I'm trying to create a SourceID that's the CompanySourceID '-'(just the year of a date with the format mm/dd/yyyy)'-' RefNum so it might look like this;

SourceID
asdf-2008-1234

UPDATE Docs
SET SourceID = CompanySourceID + '-' + SUBSTRING(DocDate, 7, 4) + RefNum

I get "Argument data type datetime is invalid for argument 1 of substring function."

I know the above query is probably way off. Your help would be greatly appreciated.

 

[gmmastros]

try...

UPDATE Docs
SET SourceID = CompanySourceID + '-' + Convert(VarChar(4), Year(DocDate)) + '-' + RefNum

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[sk8ology]

Perfect!!! Thank you so much!!