Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conversion Error from DateTime

Status
Not open for further replies.
luvmy2Js

luvmy2Js

IS-IT--Management
Joined
Sep 1, 2010
Messages
43
Location
US
I have the below code:

DATEADD(DAY,-1,CONVERT(nvarchar, DecryptBykey([last day of work])))

and it is giving me the below error:

Conversion failed when converting datetime from character string.


I have tried everything I know how, please help!!

Thanks,
 
Sort by date Sort by votes
You have bad data in your [last day of work] column.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
Why you're trying to convert Last Day of work to nvarchar?

Try converting to datetime in that code. Also, do you know the format the encrypted Last day of work is? If you know the format, try using it in the CONVERT function as last parameter.

PluralSight Learning Library
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
903
Andrzejek
Andrzejek
bharons
  • Locked
  • Question Question
Pick up value from combobox
Replies
0
Views
787
bharons
bharons
leifoet
  • Locked
  • Question Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question Question
SSRS - Subscription page error
Replies
0
Views
549
Virendra Yaduvanshi
Virendra Yaduvanshi
G12Consult
  • Locked
  • Question Question
Implicit conversion from data type error
Replies
14
Views
2K
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top