Type Into - Yesterday's Date (Decrement day)

[Tiago_Dias]

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”)

in here:

Can you please help me?

This is what I’m obtaining:

Thank you very much.
Best regards,
Tiago Dias

[StefanSchnell]

@Tiago_Dias

Hello Tiago,
please try this …

… to fill the date field.

To handle Saturday and Sunday please try this:

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

Happy automating.

Best regards
Stefan

[Yoichi]

Hi,

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

Regards,

[pawanrajpurohit]

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

[ppr (Peter Preuss)]

@Yoichi

we need to use Advanced Editor.

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

[Tiago_Dias]

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

These are my system settings:

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:

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

[ppr (Peter Preuss)]

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

[Tiago_Dias]

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,

[ppr (Peter Preuss)]

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

[ron.butler (Ron Butler Jr.)]

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.

[Mark_Rajkumar (Mar)]

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

[Rahul_Unnikrishnan]

Hello @Mark_Rajkumar

Have you tried with Modify Date activity?

How to Modify Date in UiPath? Modify Date activity explained with demo

Thanks

[Mark_Rajkumar (Mar)]

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

[Rahul_Unnikrishnan]

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

Thanks