I have created an app in UiPath based on client requirement to display certain columns of database table. Among which one of the columns ‘Entry_Date’ of type ‘Date’ should also be displayed.
The bot is working as expected when run from studio or orchestrator. However, I am facing the error - ‘Error converting value 08/25/2025 00:00:00 +02:00 to type ‘System.String’. Path ‘[54].Entry_Date’, line 1, position 88051.’ only when I am triggering the process through App.
I am posting the error screenshot, datafabric entity and filter details of the same.
Your help to solve this is highly appreciated. Thanks in advance.
This can be happening because the App is expecting a string, but the bot is returning a DateTime value. In Studio/Orchestrator it runs fine, but in Apps the serialization is stricter.
To fix it, you can try to convert the date before sending it back to the App, for example: row(“Entry_Date”).ToString(“MM/dd/yyyy”)
So instead of passing the raw DateTime, pass the formatted string. That should remove the error when triggering from the App.
I require the Entry_Date column to be of Date type in App, in order to use a date picker and apply filter. So, I cannot pass the value as string. Is there any other way to trim or remove the offset value.
I have checked this with multiple other date entries. But the issue remains the same. From the screenshot I believe that the offset ‘+02:00’ is causing the issue as a ‘+’ symbol cannot be converted to string. Is there any way that I can remove the offset before displaying it in the app.
is that the input that you are selecting on the frontend? or was that value present in your data service?
ideally not in data service is what I guess as its already in date format so should not have any issue..if from app then first parse the date string or use .ToString with format inside it..so that the format is considered
