Skip to Content
0
Former Member
Oct 30, 2012 at 10:27 AM

Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string.

102 Views

when i am executing this query then i am getting the error--

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or time from character string.

Query is --------------------------

Select

j1.Account,

isnull(max(j1.FCCurrency),'INR') as Currency,

sum(j1.Debit) as Debit,

sum(j1.credit) credit,

sum(j1.debit-j1.credit) as Balance

from

jdt1 j1

where

j1.refdate = '[%0]' ------------I think this error is generated here

Group by

j1.Account