Filtering UiPath App Data on basis of Date in Data Service

Help Apps
,
1

I am trying to filter data in Data Service by Date. Whenever a date is selected in UiPath App interface, filetred data should come up. But assigning condition is throwing error. Anyone has done this before?

I have tried converting the expression in query builder to datetime (same as in Data Service) but it does not work.

The query builder for ChemistryOrders displays multiple conditions for filtering, with an error highlighted in yellow indicating that a value of type "String" cannot be converted to "Date." (Captioned by AI)
The query builder for ChemistryOrders displays multiple conditions for filtering, with an error highlighted in yellow indicating that a value of type "String" cannot be converted to "Date." (Captioned by AI)849×698 40.3 KB

The image displays a table with columns detailing attributes like "Display Name," "Name," "Type," "Required," "Is unique," and "Description" for two entries: "Email Date" and "Email Sender." (Captioned by AI)
The image displays a table with columns detailing attributes like "Display Name," "Name," "Type," "Required," "Is unique," and "Description" for two entries: "Email Date" and "Email Sender." (Captioned by AI)953×206 11.1 KB

Forum Engagement Daily Reports
2

@tilarapiyush

Try giving cdate(mainpage.newdate.value)

Cheers

3

Not working. Gives No Data. However I have found something. When I pass a default expression in query builder, the filtered data is showing up. I have given a future date so that atleast all records show up on the App when it loads.
The requirement is to get Date input from frontend for filtering.

Default expression in Qury Builder

The image shows a software interface for setting query conditions, including a highlighted "EmailDate" field where a date parsing function is set to check if the date is less than "20/05/2026 12:00:00 am" using specific date-time formatting and culture information. (Captioned by AI)
The image shows a software interface for setting query conditions, including a highlighted "EmailDate" field where a date parsing function is set to check if the date is less than "20/05/2026 12:00:00 am" using specific date-time formatting and culture information. (Captioned by AI)862×345 30.2 KB

App with cdate(mainpage.newdate.value)

The image shows an EMEA Chemistry Order Dashboard in development, with fields for email sender, sales organization, customer name, email date, purchase order number, and various columns, yet currently displaying "No data". (Captioned by AI)
The image shows an EMEA Chemistry Order Dashboard in development, with fields for email sender, sales organization, customer name, email date, purchase order number, and various columns, yet currently displaying "No data". (Captioned by AI)1892×945 23.6 KB

App with Default expression in Query Builder.

The image displays a development dashboard for EMEA Chemistry orders, featuring search and filter fields alongside a table of order data with columns such as order status, attachment names, and processing dates. (Captioned by AI)
The image displays a development dashboard for EMEA Chemistry orders, featuring search and filter fields alongside a table of order data with columns such as order status, attachment names, and processing dates. (Captioned by AI)1744×932 50.5 KB

5

@tilarapiyush

Can you try to print what cdate is giving as output please..also which date did you select when converting

I see date is blank as per screenshot

Cheers

6

Cdate is not giving any output. Filtration is not happening by NewDate filter. It is the default
expression which is filtering.

The image displays the "EMEA Chemistry Order Dashboard - Dev" featuring fields for filtering email sender, sales org, customer name, and PO number, with a table listing order details including status, email information, and file types. (Captioned by AI)
The image displays the "EMEA Chemistry Order Dashboard - Dev" featuring fields for filtering email sender, sales org, customer name, and PO number, with a table listing order details including status, email information, and file types. (Captioned by AI)1900×853 48.5 KB

7

@tilarapiyush

cdate(mainpage.newdate.value.tostring) is working..but if date value is not given then it does not show anything try to select a date and it should be working

because when blank default date is taken and hence no filteration

Screenshot 2025-06-01 at 10.31.28 AM
Screenshot 2025-06-01 at 10.31.28 AM3414×1082 186 KB

Screenshot 2025-06-01 at 10.31.07 AM
Screenshot 2025-06-01 at 10.31.07 AM3420×1100 102 KB

Screenshot 2025-06-01 at 10.31.57 AM
Screenshot 2025-06-01 at 10.31.57 AM1590×852 48.8 KB

cheers

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.