What expression to use instead of one expression i have used in exchange to get only date time

Help Something Else
1

instead of this expression “received: >=10/24/2022 AND received: <=10/28/2022” i want to use another expression to get only in exchange to get only date time

like my outputs are coming like this
image

But i want output to be like this so how to write expression to get only date time like mentioned in exchange get mails?
image

2

HI @sathish_Kumar6

Try with expression

DateTime.ParseExact(CurrentRow(0).ToString.Trim,"ddd, dd MMM yyyy HH:mm:ss +0530",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy HH:mm:ss")

Regards
Gokul

3

HI @sathish_Kumar6

After writing the details in the excel use the Formet cells activity and give your custom format there

Regards
Sudharsan

4

If you needed only UiPath activitie you can use the modern activity formating check out the modern activities steps in the link @sathish_Kumar6

Regards
Sudharsan

5

thanks for the help its helpful but actually i mention it for to get mails from get exchange mail activities so i need to edit my topic i guess so sorry for the mistake

6

No worries @sathish_Kumar6

Can you share you sample XAML file. How did you write into the excel file?

Regards
Gokul

7

sure ill upload it actually i got some error after running anyway ill share the xaml

GreaterThanDate (1).xaml (16.1 KB)
Book1 to forum.xlsx (9.5 KB)

image

8

HI @sathish_Kumar6

This not the issue at all. In the excel file it has an empty so it appeared.

This the Output of you XAML file.

image
image1201×512 15.3 KB

Regards
Gokul

9

thank you but i also need another format so ill create new topic

1 Like
10

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