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