Creating reports and dashboards | Stimulsoft community forum

select * from boiler where date like @date
hi i have this code in my datasource and now my date is string value i want to filter my datasource like this code

select * from boiler where mid(date,1,4) like @date
i want 4 string in first of date string
thanks

Hello,

Please send us your report with sample data for analysis.

Thank you.

hi look my friend
i have a datasource that contain this text in query text
select * from boiler where date like @date
my format of date is string now i want to pick up 4 character of begin of date
i write my question in vb.net language
select * from boiler where mid(date,1,4) like @date
thanks

Hello,

Please try to use the following query in your data source: Thank you.