Expression to filter Date
Posted: Sun Jul 12, 2020 1:26 pm
Hi,
I have two date variables. One is FromDate & the other is ToDate. So based on the user selection i want to use this expression to filter. The variables FromDate & ToDate are attached to a datasource from where they get data. The user can edit this and submit. I have added the below as a filter to my databand and my chart,
When i select the desired date values there are no values returned and the graph & the databand are empty. I know for a fact there is data in the database that fulfillls the criteria I am selecting but I am not sure about my filter expression. I need your help to make sure it is correct.
The data is retreived from a mysql database & the column is a dateTime datatype.
[/img]
So the issue is that when the user selects the date it comes with the time. Is there a way to remove the time part in an expression ?
With Thanks
I have two date variables. One is FromDate & the other is ToDate. So based on the user selection i want to use this expression to filter. The variables FromDate & ToDate are attached to a datasource from where they get data. The user can edit this and submit. I have added the below as a filter to my databand and my chart,
Code: Select all
Reports_Employee_AnniversaryCopy.startDate >= FromDate && Reports_Employee_AnniversaryCopy.startDate <= ToDate
The data is retreived from a mysql database & the column is a dateTime datatype.
So the issue is that when the user selects the date it comes with the time. Is there a way to remove the time part in an expression ?
With Thanks