In SSRS I have data field called Event_dt
it returns as Digital
followed by Month, then Year. It looks like this Digital January 2021
or Digital May 2019
Question 1: In one field - I need to truncate the word Digital
so the string would only read January 2021
or May 2019
Question 2: In the second string i need to evaluate, if Event_dt
string contains the word Digital
then it should output something else. I know the iff(part ... but i'm not sure how to get the sub string part in SSRS.
Aucun commentaire:
Enregistrer un commentaire