#Error on expression

hi,

here's problem simple solve, somehow can't figure out what's going on.

my expression : =len(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre") -instrrev(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre"), ":"))

my field's value : 18 janvier 2016      heure : 13:00

there's total of 34 caracters.

i've tried split expression narrow down number of possible mistakes might have made.

len(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre")))    returns 34

instrrev(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre"), ":")    returns 32

so, 34 - 32 should return 2, #error message.

anyone has clue on one??

thank you.

---

pat

ok problem solved, seems can't subtract inside comas of len expression, did subtraction outside of comas, second parameter of "right" function.

final result :

=left(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre"), instrrev(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre"), ":") -1)  & " h "  &  right(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre"), len(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre")) - instrrev(first(fields!daterendezvous.value, "kw1a001asuivdemddesm_lettre"), ":"))

hope can someday =)

---

pat

SQL Server  >  SQL Server Reporting Services, Power View