Type Into - Yesterday's Date (Decrement day)

Help StudioX
,
1

Hi all,
I need to type yesterday’s date in a SAP field. I would also like that when it’s monday, the robot considers from previous friday to previous sunday.

I tried adding this form: DateTime.Now.AddDays(-1).ToString(“ddMMyyyyy”)

image
image982×345 37 KB

in here:
image

Can you please help me?

This is what I’m obtaining:

image
image1086×91 5.53 KB

Thank you very much.
Best regards,
Tiago Dias

2

@Tiago_Dias

Hello Tiago,
please try this …

image
image390×638 18.9 KB

… to fill the date field.

image

To handle Saturday and Sunday please try this:

image
image509×1197 25.8 KB

Saturday is minus 2 and default is the same as in the example above.

Happy automating.

Best regards
Stefan

3

Hi,

If we want to use VB.net expression in StudioX, we need to use Advanced Editor. Can you try this?

img20210813-1

Regards,

4

Hey Please first find today is Monday or not for this you can use datetime.Now.toString(“dd”) and this value in string variable day

and then check in if condition whether day is Monday or not
day == “Mon”

if condition is true then subtract your day with -2

hope you find this solution

5

Based on Yoichi’s feedback give a try on following statement:
Now.AddDays({-2,-3,-1,-1,-1,-1,-1}(Now.DayOfWeek)).ToString(“ddMMyyyyy”)

6

Hi,
Thank you all.
How do I type the date format with dots, for example 12.08.2021?

These are my system settings:
image

Will this Now.AddDays({-2,-3,-1,-1,-1,-1,-1}(Now.DayOfWeek)).ToString(“ddMMyyyyy”) solve also the weekend issue?
As mentioned, I would like that on mondays, it types, on the 1st field, the previous friday and on the 2nd field the previous sunday.

For example, if today was monday 09/08/2021, it would need to type this date interval:

image
image747×59 11.6 KB

If it was 10/08/2021 (Tuesday), it would need to type 09/08/2021 on both fields.

Thank you in advance.

Cheers,
Tiago Dias

7

Just configure the Format String usednwithin toString

Date with dots “dd.MM.yyyy”

AS by the Titel for SAT,sun,Mon IT will use the friday before. Tue,wed,thu,fri will use the das before

8

Thank you. It’s working now.

But I still don’t get it when it’s monday and I want to type an interval from previous friday to previous sunday (“yesterday”)?

Thank you,

9

Make the question more clear Just by Sharing with us some series of
Input Date: xx.xx.xxxx
Expected Output Date: xx.xx.xxxx

Thanks

10

Using Dates Example.zip (4.3 KB)
Here is a subset of a UiPath BOT I wrote that shows assigning Dates in different ways and getting the current, past or next Month, it also shows getting the output as numeric , abbeviation and full name, including day of the week with a Case statement to process day of week named activities.

11

Hi Stefan, I tried the same as you however the field does not pull in dd/MM/yyyy

12

Hello @Mark_Rajkumar

Have you tried with Modify Date activity?

Thanks

13

Hi Rahul,

I did but i wan to excluse sat and sun and only need Mon to fri.

How do i do that?

Regards,
Mark Rajkumar

14

From the activity you can get the day. Then use a if activity to check whether the day is sat or sun.

Thanks