Question about date format and related formula

Help StudioX
,
1

Hi,
I have a program that takes user input from the ‘Input Dialog’ box. The user input is a date in mm/dd/yyyy format. It’s stored in userDate variable.
Then I use Outlook activity to search for an email of that date. In ‘Additional Filters’, I select Date option and provide the input date as a parameter for the Input Dialog.
Now, when I open in advanced editor, the data looks like this Saved.Values(Of UiPath.Excel.ExcelValue)(“userDate”).

Question:
When I input 12/30/2021 (in format mm/dd/yyyy), it works fine. I get the email and related attachment.
However, most surprising, when I enter 1/2/2022, it does not download the attachment, even though there’s an email.
Can you please tell me why this is happening ? Any possible solution ?

2

@Prinal_C

Can you try by entering as 01/02/2022 ?

because the format is mm/dd/yyyy

Hope this may help you

Thanks

3

@Prinal_C

Also you can convert the input as below for your reference

Date Format Reference

Hope this may help you

Thanks

4

@Srini84 — it does not work either.

5

This did not help either

6

Hi @Prinal_C ,

I have created similar work flow in studiox. i have given the date format like 1/3/2022 you mentioned it was working in my side. i think we have to check any other filters you have used like un read email, with attachments only etc. We could test like whether we are getting the subject of email and see if you are getting any emails on that date. thanks.

image
image596×652 21.7 KB

image
image1177×556 18.6 KB

7

You have the date entered by the user as a string. You can’t compare dates as strings. You have to convert it to an actual datetime before using it to find the email.

1 Like