Extract Date and Time from Text returning wrong output

[apaukarel]

Hello There,

I’m extracting date from a string using Extract Date and Time from Text activity but it’s giving me wrong values. What’s wrong?

Output is getting - 01/01/0001 00:00:00

I’m expecting - 2025-08-31

Appreciate your guidence.

[ashokkarale]

@apaukarel,

It could be due to the Date and time format

Try passing it this way “yyyy-mm-dd”

Refer these formats the way it should be used

Strings.Format(Object, String) Method (Microsoft.VisualBasic)

[manasrlenka25 (Manas Lenka)]

@apaukarel
I tried passing yyyy-mm-dd to the DateTime format, but I faced no output result.

So, I passed it through the Expression Editor, which worked and gave the correct result.

I recommend checking the forum link below for a clearer understanding of Date & Time formats.

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (https://forum.uipath.com/t/all-about-datatable-uipath/386445) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm…